检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
Value range: Boolean on indicates that non-initial users have the permission to create, modify, and delete directories. off indicates that non-initial users do not have the permission to create, modify, and delete directories.
Value range: DML operations (such as SELECT, INSERT, DELETE, and UPDATE) or registered functions in the system catalog. WORK | TRANSACTION Specifies the optional keyword in the BEGIN syntax, which is meaningless.
Examples Create my_server, in which file_fdw is the built-in foreign data wrapper. 1 2 3 4 5 -- Create my_server. openGauss=# CREATE SERVER my_server FOREIGN DATA WRAPPER file_fdw; -- Delete my_server. openGauss=# DROP SERVER my_server; You are advised to create another server in
(num1 integer, num2 integer) RETURN integer AS BEGIN RETURN num1 + num2; END; / -- Pass by parameter value. gaussdb=# CALL func_add_sql(1, 3); -- Pass by naming tag method. gaussdb=# CALL func_add_sql(num1 => 1,num2 => 3); gaussdb=# CALL func_add_sql(num2 := 2, num1 := 3); -- Delete
a fast-refresh materialized view. gaussdb=# DROP MATERIALIZED VIEW my_imv; -- Delete the ordinary table my_table. gaussdb=# DROP TABLE my_table; Helpful Links ALTER MATERIALIZED VIEW, CREATE MATERIALIZED VIEW, CREATE TABLE, DROP MATERIALIZED VIEW, REFRESH INCREMENTAL MATERIALIZED
the complete-refresh materialized view. gaussdb=# DROP MATERIALIZED VIEW my_mv; -- Delete the ordinary table my_table. gaussdb=# DROP TABLE my_table; Helpful Links ALTER MATERIALIZED VIEW, CREATE INCREMENTAL MATERIALIZED VIEW, CREATE TABLE, DROP MATERIALIZED VIEW, REFRESH INCREMENTAL
a complete-refresh materialized view. gaussdb=# DROP MATERIALIZED VIEW my_mv; -- Delete the ordinary table my_table. gaussdb=# DROP TABLE my_table; Helpful Links ALTER MATERIALIZED VIEW, CREATE INCREMENTAL MATERIALIZED VIEW, CREATE TABLE, DROP MATERIALIZED VIEW, REFRESH INCREMENTAL
The DROP INDEX statement cannot be used to delete these indexes. You need to use the DROP INDEX IF EXISTS statement to delete them.
DBE_PLDEBUGGER.delete_breakpoint Invoked by the debug end to delete a breakpoint. DBE_PLDEBUGGER.info_breakpoints Invoked by the debug end to view all breakpoints. DBE_PLDEBUGGER.backtrace Invoked by the debug end to check the current call stack.
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 type if any objects depend on it. This is the default action. Examples For details, see Examples. Helpful Links CREATE TYPE and ALTER TYPE Parent topic: D
RESTRICT Refuses to delete the type if any objects depend on it. This is the default action. Examples See Examples. Helpful Links CREATE TYPE and ALTER TYPE Parent topic: D
based on the actual situation. gaussdb=#ALTER TABLE table_name SET (parallel_workers=4); -- Create an index. gaussdb=#CREATE INDEX index_name ON table_name(col1); -- Reset the parallel_workers parameter for the table. gaussdb=#ALTER TABLE table_name RESET (parallel_workers); -- Delete
RESTRICT: refuses to delete the server if any objects depend on it. This is the default action.
RESTRICT: refuses to delete the trigger if any objects depend on it. This is the default action. Examples For details, see Examples in CREATE TRIGGER. Helpful Links CREATE TRIGGER, ALTER TRIGGER, and ALTER TABLE Parent topic: SQL Syntax
RESTRICT Refuses to delete the type if any objects depend on it. This is the default action. Examples See Examples in section "CREATE TYPE." Helpful Links CREATE TYPE and ALTER TYPE Parent topic: SQL Syntax
RESTRICT: refuses to delete the server if any objects depend on it. This is the default action.
RESTRICT: refuses to delete the trigger if any objects depend on it. This is the default action. Examples For details, see Examples in CREATE TRIGGER. Helpful Links CREATE TRIGGER, ALTER TRIGGER, and ALTER TABLE Parent topic: SQL Syntax
user jack. gaussdb=# DROP USER jack CASCADE; -- Delete the schema. gaussdb=# DROP SCHEMA tpcds; Helpful Links GRANT and REVOKE Parent topic: A
*/ exec sql open cur1; exec sql fetch 1 in cur1 into :va, :vb; printf("c1:%d, c2:%d\n", va, vb); /* Use the WHERE CURRENT OF clause to delete the current line. */ exec sql delete t1 where current of cur1; exec sql fetch 1 in cur1 into :va, :vb; exec sql
