检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
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.
Helpful Links CREATE DATABASE Suggestions DROP DATABASE Do not delete databases during transactions. Parent topic: SQL Syntax
To modify other parameters, delete the sequence and create it again. Then, use the Setval function to restore parameter values. ALTER SEQUENCE MAXVALUE cannot be used in transactions, functions, and stored procedures.
To change other parameters, delete the sequence and create it again. Then, use the Setval function to restore parameter values. ALTER SEQUENCE MAXVALUE cannot be used in transactions, functions, and stored procedures.
SELECT * FROM myschema.mytable; | firstcol | ---+----------+ 1 | 200 | Delete the table. DROP TABLE myschema.mytable; Parent topic: Changing the Deployment Model
the tpcds.reason table. gaussdb=# DROP TABLE tpcds.reason; -- Delete the schema. gaussdb=# DROP SCHEMA tpcds; Helpful Links COMMIT | END, ROLLBACK, and SET TRANSACTION Parent topic: S
To modify other parameters, delete the sequence and create it again. Then, use the Setval function to restore parameter values. ALTER SEQUENCE MAXVALUE cannot be used in transactions, functions, and stored procedures.
the table. gaussdb=# DROP TABLE tpcds.reason; -- Delete the schema. gaussdb=# DROP SCHEMA tpcds CASCADE; Helpful Links COMMIT | END, ROLLBACK, and SET TRANSACTION Parent topic: SQL Syntax
To modify other parameters, delete the sequence and create it again. Then, use the Setval function to restore parameter values. ALTER SEQUENCE MAXVALUE cannot be used in transactions, functions, and stored procedures.
the resource label table_label. gaussdb=# DROP RESOURCE LABEL table_label; -- Delete the base table table_for_label. gaussdb=# DROP TABLE table_for_label; Helpful Links CREATE RESOURCE LABEL and DROP RESOURCE LABEL Parent topic: A
RESTRICT (default): refuses to delete the object if any objects depend on it.
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,
Insert, update, and delete rows. Create, replace, modify, and delete objects. Control the access to a database and its objects. Maintain the consistency and integrity of a database. SQL consists of commands and functions that are used to manage databases and database objects.
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.
the resource label table_label. gaussdb=# DROP RESOURCE LABEL table_label; -- Delete the base table table_for_label. gaussdb=# DROP TABLE table_for_label; Helpful Links CREATE RESOURCE LABEL and DROP RESOURCE LABEL Parent topic: A
Insert, update, and delete rows. Create, replace, modify, and delete objects. Control the access to a database and its objects. Maintain the consistency and integrity of a database. SQL consists of commands and functions that are used to manage databases and database objects.
RESTRICT: refuses to delete the object if any objects depend on it. This is the default action.
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,
Insert, update, and delete rows. Create, replace, modify, and delete objects. Control the access to a database and its objects. Maintain the consistency and integrity of a database. SQL consists of commands and functions that are used to manage databases and database objects.
RESTRICT: refuses to delete the index if any objects depend on it. This is the default action. Examples See Examples in section "CREATE INDEX." Helpful Links ALTER INDEX and CREATE INDEX Parent topic: SQL Syntax
