检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
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.
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
RESTRICT: refuses to delete the object if any objects depend on it. This is the default action.
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, and
SELECT * FROM myschema.mytable; | firstcol | ---+----------+ 1 | 200 | Delete the table. DROP TABLE myschema.mytable; Parent Topic: Changing the Deployment Model
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.
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.
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 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
DETAIL: Failing row contains (1, 1). gaussdb=# UPDATE vt SET y = 121 WHERE y = 1; UPDATE 1 gaussdb=# UPDATE vt_wco SET y = 6 WHERE y = 11; UPDATE 1 gaussdb=# DELETE FROM vt WHERE y =11; DELETE 0 -- Create a multi-layer nested view and specify WITH CHECK OPTION in the bottom-layer
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.
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: SQL Syntax
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.
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: SQL Syntax
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
