检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 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
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.
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
Global temporary tables can be created using ON COMMIT PRESERVE ROWS or ON COMMIT DELETE ROWS.
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 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
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.
RESTRICT: refuses to delete the view if any objects depend on it. This is the default action.
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
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.
-- Delete data from a specified partition. gaussdb=# DELETE FROM tbl_range_list PARTITION (p_201901); DELETE 1 gaussdb=# DELETE FROM tbl_range_list SUBPARTITION (p_201902_01001); DELETE 1 gaussdb=# DELETE FROM tbl_range_list SUBPARTITION for ('201901','01002'); DELETE 0 -- When
Method Description Return Value (res Result)RowsAffected() Returns the number of rows affected by the INSERT, DELETE, UPDATE, SELECT, MOVE, FETCH, and COPY operations. int64 and error Parent topic: Go APIs
Method Description Return Value (res Result)RowsAffected() Returns the number of rows affected by the INSERT, DELETE, UPDATE, SELECT, MOVE, FETCH, and COPY operations. int64 and error Parent topic: Go APIs
Method Description Return Value (res Result)RowsAffected() Returns the number of rows affected by the INSERT, DELETE, UPDATE, SELECT, MOVE, FETCH, and COPY operations. int64 and error Parent topic: Go APIs
Method Description Return Value (res Result)RowsAffected() Returns the number of rows affected by the INSERT, DELETE, UPDATE, SELECT, MOVE, FETCH, and COPY operations. int64 and error Parent topic: Go APIs
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: S
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.
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.
