检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
dir; -- Delete the user. gaussdb=# DROP USER jim; Helpful Links CREATE DIRECTORY and DROP DIRECTORY Parent topic: SQL Syntax
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.
the directory object. gaussdb=#DROP DIRECTORY dir; -- Delete the user. gaussdb=#DROP USER jim; Helpful Links CREATE DIRECTORY and DROP DIRECTORY Parent topic: A
dir; -- Delete the user. gaussdb=#DROP USER jim; Helpful Links CREATE DIRECTORY and DROP DIRECTORY Parent topic: A
SNAPSHOT s1@1.0; -- Delete the table. gaussdb=# DROP TABLE t1; Parent topic: SQL Syntax
the view. gaussdb=# DROP VIEW tpcds.customer_details_view_v2; -- Delete tpcds.customer_demographics_t2. gaussdb=# DROP TABLE tpcds.customer_demographics_t2; -- Delete the tpcds.customer table. gaussdb=# DROP TABLE tpcds.customer; -- Delete the schema. gaussdb=# DROP SCHEMA tpcds
If you fail to delete an object by specifying its name after truncation, specify its original name to delete it, or manually delete it from the system catalogs on each node.
a 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
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,
the directory. gaussdb=# DROP DIRECTORY dir; -- Delete the user. gaussdb=# DROP USER jim; Helpful Links CREATE DIRECTORY and DROP DIRECTORY Parent topic: SQL Syntax
the fast-refresh materialized view. openGauss=# DROP MATERIALIZED VIEW my_imv; -- Delete the my_table table. openGauss=# DROP TABLE my_table; Helpful Links ALTER MATERIALIZED VIEW, CREATE INCREMENTAL MATERIALIZED VIEW, CREATE MATERIALIZED VIEW, CREATE TABLE, DROP MATERIALIZED VIEW
the fast-refresh materialized view. openGauss=# DROP MATERIALIZED VIEW my_imv; -- Delete the my_table table. openGauss=# DROP TABLE my_table; Helpful Links ALTER MATERIALIZED VIEW, CREATE INCREMENTAL MATERIALIZED VIEW, CREATE MATERIALIZED VIEW, CREATE TABLE, DROP MATERIALIZED VIEW
END emp_bonus; / -- Delete the package. gaussdb=#DROP PACKAGE emp_bonus; -- Switch back to the initial database and delete the ORA-compatible database.
the reason and reason_t1 tables. m_db=# DROP TABLE tpcds.reason; m_db=# DROP TABLE tpcds.reason_t1; -- Delete the schema. m_db=# DROP SCHEMA tpcds; Parent topic: E
the tpcds.reason table. gaussdb=# DROP TABLE tpcds.reason; -- Delete a schema. gaussdb=# DROP SCHEMA tpcds; Helpful Links COMMIT | END, ROLLBACK, and SET TRANSACTION Parent topic: SQL Syntax
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.
The ADD USER and DROP USER clauses are used to add users to or delete users from a user group. Any user can be considered a user group. The two clauses are equivalent to granting and recycling memberships respectively.
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
