检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
a masking policy. gaussdb=# DROP MASKING POLICY maskpol1; -- Delete resource labels. gaussdb=# DROP RESOURCE LABEL mask_lb1, mask_lb2; - Delete the tb_for_masking table. gaussdb=# DROP TABLE tb_for_masking; -- Delete the dev_mask and bob_mask users. gaussdb=# DROP USER dev_mask
a masking policy. gaussdb=# DROP MASKING POLICY maskpol1; -- Delete resource labels. gaussdb=# DROP RESOURCE LABEL mask_lb1, mask_lb2; -- Delete the tb_for_masking table. gaussdb=# DROP TABLE tb_for_masking; -- Delete the dev_mask and bob_mask users. gaussdb=# DROP USER dev_mask
To delete a cluster node, you only need to connect to one CN. If a cluster node is created on only one CN, to delete the cluster node, you need to define the current CN name and delete the cluster node on the current CN. For details, see DROP NODE.
Delete user jack. 1 2 gaussdb=# DROP USER jack CASCADE; DROP ROLE Delete tables foo and foo2. 1 2 gaussdb=# DROP TABLE foo; gaussdb=# DROP TABLE foo2; If the following information is displayed, the operation is successful: 1 DROP TABLE Delete tablespace fspace. 1 2 gaussdb=# DROP
1 DROP TABLE Run the following command to delete tablespace fspace: 1 2 openGauss=# DROP TABLESPACE fspace; DROP TABLESPACE Only the tablespace owner or system administrator can delete a tablespace.
Global temporary tables can be created using ON COMMIT PRESERVE ROWS or ON COMMIT DELETE ROWS.
Database Programming Specifications GUC Parameter Programming Specifications Object Access Programming Specifications WHERE SELECT INSERT UPDATE DELETE Join Query Subquery Transaction SQL Compilation DDL Parent topic: Development and Design Proposal
After an object is created, only the object owner or system administrator can query, modify, and delete the object, and grant permissions for the object to other users through GRANT by default.
After an object is created, only the object owner or system administrator can query, modify, and delete the object, and grant permissions for the object to other users through GRANT by default.
Run the following command to delete MyView: 1 2 openGauss=# DROP VIEW MyView; DROP VIEW Parent topic: Other Operations
a public database link. gaussdb=#DROP PUBLIC DATABASE LINK public_dblink; -- Delete the created user. gaussdb=#RESET ROLE; gaussdb=#DROP USER user1; gaussdb=#DROP USER user2; Helpful Links CREATE DATABASE LINK and DROP DATABASE LINK Parent topic: A
the tpcds.customer_demographics_t2 table. gaussdb=#DROP TABLE tpcds.customer_demographics_t2; -- Delete the schema. gaussdb=#DROP SCHEMA tpcds; Helpful Links ROLLBACK Parent topic: C
A new record is displayed. test_event=# SELECT * FROM t_ev; num ----- 0 1 1 (3 rows) -- Delete the scheduled event. test_event=# DROP EVENT event_e2; -- Drop the table. test_event=# DROP TABLE t_ev; -- Switch back to the initial database and delete the test database.
GaussDB supports the access of content in an array by using parentheses, and the extend, count, first, last prior, next, exists, trim, and delete functions.
the complete-refresh materialized view. gaussdb=#DROP MATERIALIZED VIEW my_mv; -- Delete the ordinary table my_table. gaussdb=#DROP TABLE my_table; -- Delete the tablespace. gaussdb=#DROP TABLESPACE tbs_data1; Helpful Links ALTER MATERIALIZED VIEW, CREATE INCREMENTAL MATERIALIZED
FOR SHARE/UPDATE is used to lock rows in a transaction, other transactions cannot modify or delete these rows. When FOR SHARE is used to lock a row, the current transaction and other transactions cannot modify or delete the locked row.
Examples -- Create a schema. gaussdb=# CREATE SCHEMA tpcds; -- Delete the tpcds.reason_t2 table.
Examples -- Create a schema. gaussdb=# CREATE SCHEMA tpcds; -- Delete the tpcds.reason_t2 table.
DBE_PLDEBUGGER.delete_breakpoint Called by the debug end to delete a breakpoint. DBE_PLDEBUGGER.info_breakpoints Called by the debug end to view all breakpoints. DBE_PLDEBUGGER.backtrace Called by the debug end to check the current call stack.
the tpcds.reason_t1 table. gaussdb=# DROP TABLE tpcds.reason_t1; -- Delete the table. gaussdb=# DROP TABLE tpcds.reason; -- Delete the schema. gaussdb=# DROP SCHEMA tpcds CASCADE; Helpful Links SELECT Suggestions DATABASE You are advised not to re-index a database in a transaction
