检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
Step 2: Delete Table Data Delete the instance. Step 3: Restore Table Data Restore the deleted table data using table-level point-in-time recovery (PITR). Step 4: Check the Results Log in to the DAS console and check whether the data was restored.
Step 2: Delete Table Data Delete the instance. Step 3: Restore Table Data Restore the deleted table data using a table-level backup. Step 4: Check the Results Log in to the DAS console and check whether the data was restored.
the scheduled tasks. test_event=# DROP EVENT event_e2; test_event=# DROP EVENT test.event_e3; -- Delete the table. test_event=# DROP TABLE t_ev; -- Delete a schema. test_event=# DROP SCHEMA test; -- Switch back to the initial database and delete the test database.
After an object is created, only the object owner or system administrators can query, modify, and delete the object, and grant permissions for the object to other users through GRANT by default.
Replace init_user with the actual initial username. gaussdb=# \c - init_user -- Delete user sysadmin. gaussdb=# DROP USER sysadmin; Helpful Links CREATE SYNONYM and DROP SYNONYM Parent topic: SQL Syntax
After an object is created, only the object owner or system administrators can query, modify, and delete the object, and grant permissions for the object to other users through GRANT by default.
FOR SHARE/UPDATE is used to lock rows in a transaction, other transactions cannot modify or delete these rows. When FOR SHARE is used to lock a row, the current transaction and other transactions cannot modify or delete the locked row.
After an object is created, only the object owner or system administrators can query, modify, and delete the object, and grant permissions for the object to other users through GRANT by default.
After an object is created, only the object owner or system administrator can query, modify, and delete the object, and grant permissions for the object to other users through GRANT by default.
Replace init_user with the actual initial username. gaussdb=#\c - init_user -- Delete user sysadmin. gaussdb=#DROP USER sysadmin; Helpful Links CREATE SYNONYM and DROP SYNONYM Parent topic: A
You can see 3 and 4 at the same time. gaussdb=#SELECT * FROM tpcds.table1; a --- 3 4 (2 rows) -- Delete the table. gaussdb=#DROP TABLE tpcds.table1; -- Delete a schema. gaussdb=#DROP SCHEMA tpcds CASCADE; Helpful Links SAVEPOINT and ROLLBACK TO SAVEPOINT Parent topic: R
FROM ledgernsp.usertable WHERE id = 3; DELETE 1 gaussdb=# SELECT *, hash_69dd43 FROM ledgernsp.usertable ORDER BY id; id | name | hash_69dd43 ----+------+------------------ 1 | alex | 1f2e543c580cb8c5 2 | bob2 | 437761affbb7c605 (2 rows) Delete tables and schemas.
FROM ledgernsp.usertable WHERE id = 3; DELETE 1 gaussdb=# SELECT *, hash_69dd43 FROM ledgernsp.usertable ORDER BY id; id | name | hash_69dd43 ----+------+------------------ 1 | alex | 1f2e543c580cb8c5 2 | bob2 | 437761affbb7c605 (2 rows) Delete tables and schemas.
action ] [ ON UPDATE action ] You can run REFERENCES reftable[(refcolumn)] [MATCH FULL |MATCH PARTIAL | MATCH SIMPLE] [ON DELETE action] [ON UPDATE action] to create foreign key constraints for tables.
RESTRICT: refuses to delete the server if any objects depend on it. This is the default action.
Value range: an existing role name Examples -- Create role role11. gaussdb=# CREATE ROLE role11 PASSWORD '********'; CREATE ROLE -- Delete role role11. gaussdb=# DROP ROLE IF EXISTS role11; DROP ROLE -- Delete role role12 that does not exist. gaussdb=# DROP ROLE IF EXISTS role12
Value range: an existing role name Examples -- Create role role11. gaussdb=# CREATE ROLE role11 PASSWORD '********'; CREATE ROLE -- Delete role role11. gaussdb=# DROP ROLE IF EXISTS role11; DROP ROLE -- Delete role role12 that does not exist. gaussdb=# DROP ROLE IF EXISTS role12
RESTRICT: refuses to delete the server if any objects depend on it. This is the default action.
A valid command is one of the SELECT, INSERT, UPDATE, and DELETE statements.
RESTRICT: refuses to delete the synonym if any objects depend on it. This is the default action.
