检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
RESTRICT: refuses to delete the index if any objects depend on it. This is the default action. Examples See Examples in section "CREATE INDEX." Helpful Links ALTER INDEX and CREATE INDEX Parent topic: SQL Syntax
Helpful Links ALTER TABLESPACE and CREATE TABLESPACE Suggestions DROP TABLESPACE Do not delete tablespaces during transactions. Parent topic: SQL Syntax
RESTRICT: refuses to delete the view if any objects depend on it. This is the default action. Examples See Examples in section "CREATE VIEW." Helpful Links ALTER VIEW and CREATE VIEW Parent topic: SQL Syntax
It must be unique in the session. data_type Specifies the type of an argument. statement Specifies a SELECT, INSERT, UPDATE, DELETE, MERGE INTO, or VALUES statement. Examples See Examples in section "EXECUTE." Helpful Links DEALLOCATE Parent topic: SQL Syntax
For security purposes, only the initial user can create, modify, and delete DIRECTORY objects by default.
DROP: allows users to delete a specified object. has_nodegroup_privilege(nodegroup, privilege) Description: Checks whether a user has permission to access a cluster node.
the data record. gaussdb=# DELETE FROM tbl_test; -- Insert a data record again.
the data record. gaussdb=# DELETE FROM tbl_test; -- Insert a data record again.
Step 3: Verify the Upgrade After the upgrade is complete, check the instance status, backup creation status, and instance connectivity, and whether you can add, delete, update, and query data in the instance.
System administrators and common users cannot perform DROP, ALTER, DELETE, UPDATE, and INSERT operations, but can perform the SELECT operation.
the foreign table. gaussdb=# DROP FOREIGN TABLE foreign_tbl; -- Delete the server. gaussdb=# DROP SERVER my_server; Helpful Links 8.15.72 CREATE FOREIGN TABLE and DROP FOREIGN TABLE Parent topic: A
Two clauses (ADD USER and DROP USER) are used to add users to or delete users from a user group. Any user can be a user or a user group. These two clauses are equivalent to granting or revoking the permissions of a user or role to other users or roles.
Can create, modify, delete, access, or grant permissions for tablespaces. Cannot create, modify, delete, or grant permissions for tablespaces and can access tablespaces if the access permission is granted. Schemas Has all permissions for all schemas except dbe_perf.
Operation You can click Delete to delete an alarm policy. Toggle on next to the Alarm Notification field to enable alarm notification. The notification window is 24 hours by default.
the table. gaussdb=# DROP TABLE tpcds.reason; -- Delete a schema. gaussdb=# DROP SCHEMA tpcds CASCADE; Helpful Links CLOSE and FETCH Parent topic: SQL Syntax
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
Set it to NULL. privilege character varying(40) Permissions on an object, including USAGE, UPDATE, DELETE, INSERT, CONNECT, SELECT, and EXECUTE. grantable character varying(3) Specifies whether the grant contains the GRANT option.
SUMMARY_WORKLOAD_SQL_COUNT columns Name Type Description node_name name Node name. workload name Workload name. select_count bigint Number of SELECT statements. update_count bigint Number of UPDATE statements. insert_count bigint Number of INSERT statements. delete_count bigint Number of DELETE
If a temporary table is used, delete the temporary table before you return the connection to the connection pool. If you do not do so, the connection state in the connection pool will remain, which affects subsequent operations using the connection pool.
Helpful Links CREATE DATABASE Suggestions DROP DATABASE Do not delete databases during transactions. Parent topic: SQL Syntax
