检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
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
a public database link. ora_test_db=# DROP PUBLIC DATABASE LINK public_dblink; -- Delete the user. ora_test_db=# RESET ROLE; ora_test_db=# DROP USER user01; ora_test_db=# DROP USER user2; -- Switch back to the initial database and delete the test database.
a public database link. ora_test_db=# DROP PUBLIC DATABASE LINK public_dblink; -- Delete the user. ora_test_db=# RESET ROLE; ora_test_db=# DROP USER user01; ora_test_db=# DROP USER user2; -- Switch back to the initial database and delete the test database.
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
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
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
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
Do not add, delete, or modify system catalogs because doing so will result in exceptions or even database unavailability. For details about column types in system catalogs and system views, see Data Types. Parent topic: System Catalogs and System Views
Do not add, delete, or modify system catalogs because doing so will result in exceptions or even database unavailability. For details about column types in system catalogs and system views, see Data Type. Parent topic: System Catalogs and System Views
Examples -- Create the adt1 policy. gaussdb=#CREATE AUDIT POLICY adt1 PRIVILEGES CREATE; CREATE AUDIT POLICY -- Delete the audit policy adt1. gaussdb=#DROP AUDIT POLICY adt1; DROP AUDIT POLICY -- When you delete the audit policy adt0 that does not exist, the system displays a message
You are advised not to write, modify, or delete the redis_bucket_expansion parameter. The parameter name has been used to indicate that the cluster is being scaled. Parent topic: Other System Catalogs
Global temporary tables can be created using ON COMMIT PRESERVE ROWS or ON COMMIT DELETE ROWS.
r_reason_sk < 6 ); gaussdb=# DELETE FROM tpcds.reason_t1 WHERE r_reason_sk = 7; gaussdb=# COMMIT; -- Delete the tpcds.reason_t1 table. gaussdb=# DROP TABLE tpcds.reason_t1; -- Delete the table. gaussdb=# DROP TABLE tpcds.reason; -- Delete a schema. gaussdb=# DROP SCHEMA tpcds
the view. gaussdb=# DROP VIEW tpcds.customer_details_view_v2; -- Delete the tpcds.customer_demographics_t2 table. gaussdb=# DROP TABLE tpcds.customer_demographics_t2; -- Delete the tpcds.customer table. gaussdb=# DROP TABLE tpcds.customer; -- Delete a schema. gaussdb=# DROP SCHEMA
If you fail to delete an object whose name is truncated mistakenly, specify its original name to delete it, or manually delete it from the corresponding system catalog on each node.
If you fail to delete an object whose name is truncated mistakenly, specify its original name to delete it, or manually delete it from the corresponding system catalog on each node.
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 ] }; Change the filter criteria in the audit policy.
the test_clean_connection database. gaussdb=#DROP DATABASE test_clean_connection; -- Delete user jack. gaussdb=#DROP USER jack; Parent topic: C
You can delete and re-create system catalogs, add columns to them, and insert and update values in them, but doing so may make system information inconsistent and cause system faults. Generally, users should not modify system catalogs or system views, or rename their schemas.
CREATE TABLESPACE Suggestions Do not delete tablespaces during transactions using DROP TABLESPACE.
