检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
RESTRICT: refuses to delete the synonym if any objects depend on it. This is the default action.
If you directly delete the frozen instance, its automated backups will also be deleted and the backup space will not be billed any longer. Parent Topic: Backup and Restoration
the savepoint. gaussdb=# RELEASE SAVEPOINT my_savepoint; -- Commit the transaction. gaussdb=# COMMIT; -- Query the table content, which should contain both 3 and 4. gaussdb=# SELECT * FROM tpcds.table1; -- Delete the table. gaussdb=# DROP TABLE tpcds.table1; -- Delete a schema
Delete columns. Rename columns. Set and delete default values of columns. Change column lengths. Change column precisions. Change column types. Change definitions of ENUM/SET columns. When data needs to be reorganized, the time required depends on the data volume.
For example, run the following command to delete an empty schema named nullschema: 1 2 openGauss=# DROP SCHEMA IF EXISTS nullschema; DROP SCHEMA To delete a schema that is not null, use the keyword CASCADE to delete it and all its objects.
For example, run the following command to delete an empty schema named nullschema: 1 2 openGauss=# DROP SCHEMA IF EXISTS nullschema; DROP SCHEMA To delete a schema that is not null, use the keyword CASCADE to delete it and all its objects.
] 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 aggregate function if any objects depend on it. This is a default processing.
RESTRICT Refuses to delete the aggregate function if any objects depend on it. This is a default processing.
] 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.
FROM works WHERE w_id = 90020; DELETE 1 -- View data in the subtable.
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.
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
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
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
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.
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
