检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
Examples 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 -- Delete all employees in a department from the EMP table. If the department has no employees, delete the department from the DEPT table.
Examples 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 -- Delete all employees in a department from the hr.staffs table. If the department has no employees, delete the department from the hr.department table.
If the department has no employees, delete the department from the hr.department table. gaussdb=# CREATE OR REPLACE PROCEDURE proc_cursor3() AS DECLARE V_DEPTNO NUMBER(4) := 100; BEGIN DELETE FROM hr.staffs WHERE section_id = V_DEPTNO; -- Proceed based
Precautions When enable_access_server_directory is set to off, only the initial user is allowed to delete directory objects.
-- Delete the view resource label view_for_label. gaussdb=# DROP VIEW view_for_label; -- Delete the schema resource label schema_for_label. gaussdb=# DROP SCHEMA schema_for_label; -- Delete the tb_for_label table. gaussdb=# DROP TABLE tb_for_label; Helpful Links ALTER RESOURCE
Precautions When enable_access_server_directory is set to off, only the initial user is allowed to delete directory objects.
Adding the CASCADE option can forcibly delete the extension and objects that depend on it. Parent topic: SQL Syntax
Precautions Only the table owner or administrators can delete a row-level security policy from the table.
This API can only be used to delete a schema at a time. Debugging You can debug this API in API Explorer.
Precautions Only the table owner or administrators can delete a row-level security policy from the table.
Precautions Only the table owner or administrators can delete a row-level security policy from the table.
the test_clean_connection database. gaussdb=#DROP DATABASE test_clean_connection; -- Delete user jack. gaussdb=#DROP USER jack; Parent topic: C
the test_clean_connection database. m_db=# DROP DATABASE test_clean_connection; -- Delete user jack. m_db=# DROP USER jack; Parent topic: C
Precautions In the current version, you cannot delete the procedural language features created, so this syntax cannot be used. Parent topic: D
Precautions In the current version, you cannot delete the procedural language features created, so this syntax cannot be used. Parent topic: D
Precautions LOAD DATA requires the INSERT and DELETE permissions on tables. When the enable_copy_server_files parameter is disabled, only the initial user is allowed to execute LOAD DATA.
Before deleting a user, you need to delete all the objects owned by the user and revoke the user's permissions on other objects. Alternatively, you can specify CASCADE to delete the objects owned by the user and the granted permissions.
On the displayed page, locate the manual backup you want to delete and click Delete in the Operation column. Figure 1 Deleting a manual backup Click OK. After the backup is deleted, it will not be displayed on the Backups page.
You may use this statement to delete a specific user's connections to a specified database. Precautions GaussDB does not support specified nodes and supports only TO ALL. This function can be used to clear the normal connections that are being used only in force mode.
DROP RESOURCE LABEL Description DROP RESOURCE LABEL is used to delete a resource label. Precautions Only users with the POLADMIN or SYSADMIN permission, or the initial user can perform this operation.
