检测到您已登录华为云国际站账号,为了您更好的体验,建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
-- Delete the view resource label view_for_label. gaussdb=# DROP VIEW view_for_label; -- Delete the schema resource label schema_for_label. gaussdb=# DROP SCHEMA schema_for_label; -- Delete the tb_for_label table. gaussdb=# DROP TABLE tb_for_label; Helpful Links ALTER RESOURCE
Precautions When enable_access_server_directory is set to off, only the initial user is allowed to delete directory objects.
Adding the CASCADE option can forcibly delete the extension and objects that depend on it. Parent topic: SQL Syntax
This API can only be used to delete a schema at a time. URI DELETE /v3/{project_id}/instances/{instance_id}/schema Table 1 Parameter description Parameter Mandatory Type Description project_id Yes String Definition Project ID of a tenant in a region.
Precautions Only the table owner or administrators can delete a row-level security policy from the table.
Precautions Only the table owner or administrators can delete a row-level security policy from the table.
Precautions Only the table owner or administrators can delete a row-level security policy from the table.
the test_clean_connection database. gaussdb=# DROP DATABASE test_clean_connection; -- Delete user jack. gaussdb=# DROP USER jack; Parent topic: C
Precautions In the current version, you cannot delete the procedural language features created, so this syntax cannot be used. Parent topic: D
Precautions In the current version, you cannot delete the procedural language features created, so this syntax cannot be used. Parent topic: D
Before deleting a user, you need to delete all the objects owned by the user and revoke the user's permissions on other objects. Alternatively, you can specify CASCADE to delete the objects owned by the user and the granted permissions.
On the displayed page, locate the manual backup you want to delete and click Delete in the Operation column. Figure 1 Deleting a manual backup Click OK. After the backup is deleted, it will not be displayed on the Backups page.
You may use this statement to delete a specific user's connections to a specified database. Precautions GaussDB does not support specified nodes and supports only TO ALL. This function can be used to clear the normal connections that are being used only in force mode.
DROP RESOURCE LABEL Description DROP RESOURCE LABEL is used to delete a resource label. Precautions Only users with the POLADMIN or SYSADMIN permission, or the initial user can perform this operation.
Deleting a Database Function This API is used to delete a database from a specified DB instance. Before calling this API: Learn how to authenticate this API. Obtain the required region and endpoint. Constraints This API can only be used to delete a single database.
DROP USER MAPPING Description DROP USER MAPPING is used to delete the user mapping from a user to a foreign server.
Deleting a SQL Throttling Task Function This API is used to delete a SQL throttling task. Before calling this API: Learn how to authenticate this API. Obtain the required region and endpoint. Constraints SQL throttling tasks cannot be deleted in batches.
You may use this statement to delete a specific user's connections to a specified database. Precautions GaussDB does not support specified nodes and supports only TO ALL. This function can be used to clear the normal connections that are being used only in force mode.
DBE_SQL_UTIL.drop_sql_patch drop_sql_patch is an interface function used to delete SQL patches. It returns whether the execution is successful. Only the initial user, sysadmin, opradmin, and monadmin have the permission to invoke this interface.
You can run ALTER TABLE DROP PARTITION to delete any partition from a range partitioned table or list partitioned table. For example, delete the partition date_202005 from the range partitioned table range_sales by specifying the partition name and update the global index.