检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
table tb1. gaussdb=# DROP TABLE tbl; -- Delete user bob. gaussdb=# DROP USER bob; -- Delete the existing security label sec_label. gaussdb=# DROP SECURITY LABEL sec_label; Helpful Links CREATE SECURITY LABEL and DROP SECURITY LABEL Parent topic: S
DELETE NODE ( nodename [, ... ] ) Deletes nodes from the node group specified by groupname. The deleted nodes still exist in the PGXC_NODE system catalog. This statement only modifies the system catalog and does not delete nodes or redistribute data. Do not call this statement.
DELETE NODE ( nodename [, ... ] ) Deletes nodes from the node group specified by groupname. The deleted nodes still exist in the PGXC_NODE system catalog. This statement only modifies the system catalog and does not delete nodes or redistribute data. Do not call this statement.
data from the PLAN_TABLE table and delete tables foo1 and foo2. gaussdb=# DELETE FROM plan_table WHERE STATEMENT_ID = 'TPCH-Q4'; gaussdb=# DROP TABLE foo1; gaussdb=# DROP TABLE foo2; Example 2 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 28 --
DELETE NODE ( nodename [, ... ] ) Deletes nodes from the node group specified by groupname. The deleted nodes still exist in the PGXC_NODE system catalog. This statement only modifies the system catalog and does not delete nodes or redistribute data. Do not call this statement.
The initial user is not allowed to create, modify, or delete database links. If the upgrade is not committed, the database link cannot be created.
the directory object. gaussdb=# DROP DIRECTORY dir; -- Delete the user. gaussdb=# DROP USER jim; Helpful Links CREATE DIRECTORY and DROP DIRECTORY Parent topic: A
END emp_bonus; / -- Delete the package. gaussdb=# DROP PACKAGE emp_bonus; -- Switch back to the initial database and delete the ORA-compatible database.
a fast-refresh materialized view. gaussdb=# DROP MATERIALIZED VIEW my_imv; -- Delete the my_table table. gaussdb=# DROP TABLE my_table; Helpful Links ALTER MATERIALIZED VIEW, CREATE INCREMENTAL MATERIALIZED VIEW, CREATE MATERIALIZED VIEW, CREATE TABLE, DROP MATERIALIZED VIEW, and
the fast-refresh materialized view. openGauss=# DROP MATERIALIZED VIEW my_imv; -- Delete the my_table table. openGauss=# DROP TABLE my_table; Helpful Links ALTER MATERIALIZED VIEW, CREATE INCREMENTAL MATERIALIZED VIEW, CREATE MATERIALIZED VIEW, CREATE TABLE, DROP MATERIALIZED VIEW
the fast-refresh materialized view. openGauss=# DROP MATERIALIZED VIEW my_imv; -- Delete the my_table table. openGauss=# DROP TABLE my_table; Helpful Links ALTER MATERIALIZED VIEW, CREATE INCREMENTAL MATERIALIZED VIEW, CREATE MATERIALIZED VIEW, CREATE TABLE, DROP MATERIALIZED VIEW
the fast-refresh materialized view. gaussdb=# DROP MATERIALIZED VIEW my_imv; -- Delete the my_table table. gaussdb=# DROP TABLE my_table; Helpful Links ALTER MATERIALIZED VIEW, CREATE INCREMENTAL MATERIALIZED VIEW, CREATE MATERIALIZED VIEW, CREATE TABLE, DROP MATERIALIZED VIEW,
the directory. gaussdb=# DROP DIRECTORY dir; -- Delete the user. gaussdb=# DROP USER jim; Helpful Links CREATE DIRECTORY and DROP DIRECTORY Parent topic: SQL Syntax
If you fail to delete an object by specifying its name after truncation, specify its original name to delete it, or manually delete it from the system catalogs on each node.
the test_clean_connection database. gaussdb=# DROP DATABASE test_clean_connection; -- Delete user jack. gaussdb=# DROP USER jack; Parent topic: C
SNAPSHOT s1@1.0; -- Delete the table. gaussdb=# DROP TABLE t1; Parent topic: SQL Syntax
the view. gaussdb=# DROP VIEW tpcds.customer_details_view_v2; -- Delete tpcds.customer_demographics_t2. gaussdb=# DROP TABLE tpcds.customer_demographics_t2; -- Delete the tpcds.customer table. gaussdb=# DROP TABLE tpcds.customer; -- Delete the schema. gaussdb=# DROP SCHEMA tpcds
the tpcds.reason table. gaussdb=# DROP TABLE tpcds.reason; -- Delete a schema. gaussdb=# DROP SCHEMA tpcds; Helpful Links COMMIT | END, ROLLBACK, and SET TRANSACTION Parent topic: SQL Syntax
Syntax Add or delete an operation type in the audit policy. ALTER AUDIT POLICY [ IF EXISTS ] policy_name { ADD | REMOVE } { [ privilege_audit_clause ] [ access_audit_clause ] }; Modify the filter criteria in the audit policy.
On the Instances page, locate the instance you want to delete, click More in the Operation column, and choose Delete. In the Delete DB Instance dialog box, enter DELETE, select the confirmation check box in the Confirm field, and click OK.
