检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
Examples 1 2 3 4 5 -- Delete a masking policy. gaussdb=# DROP MASKING POLICY IF EXISTS maskpol1; -- Delete a group of anonymization policies. gaussdb=# DROP MASKING POLICY IF EXISTS maskpol1, maskpol2, maskpol3; Helpful Links ALTER MASKING POLICY and CREATE MASKING POLICY Parent
Examples 1 2 3 4 5 -- Delete a resource label. gaussdb=# DROP RESOURCE LABEL IF EXISTS res_label1; -- Delete a group of resource labels. gaussdb=# DROP RESOURCE LABEL IF EXISTS res_label1, res_label2, res_label3; Helpful Links ALTER RESOURCE LABEL and CREATE RESOURCE LABEL Parent
To add or delete users in an existing role, use ALTER ROLE. To delete a role, use DROP ROLE. DROP ROLE deletes only a role, rather than member users in the role. Built-in Roles GaussDB provides a group of default roles whose names start with gs_role_.
Exercise caution when using the DELETE statement to delete a single element. Otherwise, the element sequence may be incorrect.
Exercise caution when using the DELETE statement to delete a single element. Otherwise, the element sequence may be incorrect.
Exercise caution when using the DELETE statement to delete a single element. Otherwise, the element sequence may be incorrect.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
