检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 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
A valid command is one of the SELECT, INSERT, UPDATE, and DELETE statements.
the application mapping group. openGauss=# DROP APP WORKLOAD GROUP MAPPING app_wg_map1; openGauss=# DROP APP WORKLOAD GROUP MAPPING app_wg_map2; -- Delete the workload group. openGauss=# DROP WORKLOAD GROUP group1; -- Delete the resource pool. openGauss=# DROP RESOURCE POOL pool1
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
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
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.
RESTRICT Refuses to delete the aggregate function if any objects depend on it. This is a default processing.
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.
RESTRICT Refuses to delete the aggregate function if any objects depend on it. This is a default processing.
RESTRICT: refuses to delete the synonym if any objects depend on it. This is the default 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.
] 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.
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.
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.
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; Parent topic: E
