检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
Deleting a Manual Backup You can delete manual backups for instances and tables to release storage space. This practice describes how to delete manual backups of an instance.
Do not add, delete, or modify tables in the snapshot schema. Manual modification or damage to these tables may cause WDR exceptions or even WDR unavailability. Original Information of WDR Snapshots WDR Snapshot Data Table Parent topic: Schemas
Manual full backups You can manually delete manual backups. For details, see Deleting a Manual Backup. After the manual backups are deleted, you can go to the Instances page and click the name of the target instance to go to the Basic Information page.
To delete it, you must call PQclear. Otherwise, memory leakage occurs. Example For details, see Typical Application Development Examples. Parent topic: Database Statement Execution Functions
Initial database users can write, modify, and delete parameters in system catalogs by using ALTER and DROP.
Initial database users can write, modify, and delete parameters in system catalogs by using ALTER and DROP.
(IUD) operations on the specified partition. -- Delete all data from the p_list_5 partition. gaussdb=# DELETE FROM list_02 PARTITION (p_list_5); -- Insert data into the specified partition p_list_7.
DML Specifies the operations that are audited within the database: SELECT, COPY, DEALLOCATE, DELETE, EXECUTE, INSERT, PREPARE, REINDEX, TRUNCATE, and UPDATE. ALL Specifies all operations supported by the specified DDL or DML statements in the database.
the test_v1 view. gaussdb=# DROP VIEW tcpds.test_v1; DROP VIEW -- Delete the test_tb1 table. gaussdb=# DROP TABLE test_tb1; DROP TABLE -- Delete the user. gaussdb=# DROP ROLE role_test; DROP ROLE -- Delete the schema. gaussdb=# DROP SCHEMA tcpds; DROP SCHEMA Helpful Links CREATE
You can delete a partition by specifying the partition name or partition value. This command cannot be applied to hash partitions. Running this command will invalidate the global index.
);"; EXEC SQL END DECLARE SECTION; EXEC SQL EXECUTE IMMEDIATE :stmt; EXECUTE IMMEDIATE can be used for SQL statements that do not return a result set, such as DDL, INSERT, UPDATE, and DELETE statements.
);"; EXEC SQL END DECLARE SECTION; EXEC SQL EXECUTE IMMEDIATE :stmt; EXECUTE IMMEDIATE can be used for SQL statements that do not return a result set, such as DDL, INSERT, UPDATE, and DELETE statements.
How Can I Delete the GaussDB Backup Policy?
Do not add, delete, or modify tables in the snapshot schema. Manual modification or damage to these tables may cause WDR exceptions or even WDR unavailability. Original Information of WDR Snapshots WDR Snapshot Data Table WDR Information Parent topic: Schemas
);"; EXEC SQL END DECLARE SECTION; EXEC SQL EXECUTE IMMEDIATE :stmt; EXECUTE IMMEDIATE can be used for SQL statements that do not return a result set, such as DDL, INSERT, UPDATE, and DELETE statements.
);"; EXEC SQL END DECLARE SECTION; EXEC SQL EXECUTE IMMEDIATE :stmt; EXECUTE IMMEDIATE can be used for SQL statements that do not return a result set, such as DDL, INSERT, UPDATE, and DELETE statements.
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.
RESTRICT: refuses to delete the synonym if any objects depend on it. This is the default action. Examples See Examples in section "CREATE SYNONYM." Helpful Links ALTER SYNONYM and CREATE SYNONYM Parent topic: SQL Syntax
RESTRICT: refuses to delete the synonym if any objects depend on it. This is the default action. Examples See Examples in section "CREATE SYNONYM." Helpful Links ALTER SYNONYM, CREATE SYNONYM Parent topic: SQL Syntax
DELETE Enable DELETE. Level: global, database, and table. DROP Allows you to delete databases, tables, or views. Level: global, database, and table. EVENT Enable scheduled tasks. Level: global and database. EXECUTE Allows you to execute stored procedures.
