DROP TABLE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ] Parameters IF EXISTS Clause that indicates that if the specified table doesn’t exist, the command should make no changes and return a message that
Include theRESTRICTkeyword to specify that the server should refuse to drop the table if any objects depend on it. This is the default behavior; theDROP TABLEcommand will report an error if any objects depend on the table. Include theCASCADEclause to drop any objects that depend on the table...
DROP TABLEalways removes any indexes, rules, triggers, and constraints that exist for the target table. However, to drop a table that is referenced by a view or a foreign-key constraint of another table,CASCADEmust be specified. (CASCADEwill remove a dependent view entirely, but in the fore...
The specified table is dropped from the schema. All privileges, constraints, indexes, and triggers on the table are also dropped. Any aliases that reference the specified table are not dropped. Neither CASCADE nor RESTRICT Specifies that the table will be dropped even if it is referenced in a...
You must first disable the table's use of the flashback archive. CASCADE CONSTRAINTS Specify CASCADE CONSTRAINTS to drop all referential integrity constraints that refer to primary and unique keys in the dropped table. If you omit this clause, and such referential integrity constraints exist, then...
(CASCADE will remove a dependent view entirely, but in the foreign-key case it will only remove the foreign-key constraint, not the other table entirely.) 1. Name DELETE -- delete rows of a table 1. Synopsis DELETE FROM [ ONLY ] table ...
阿里云为您提供在数据库中 drop table相关的76570条产品文档内容及常见问题解答内容,还有等云计算产品文档及常见问题解答。如果您想了解更多云计算产品,就来阿里云帮助文档查看吧,阿里云帮助文档地址https://help.aliyun.com/。
CASCADE Removes the notifier from any data collector (DC) table policies before dropping the notifier. If the notifier is set for a DC table and CASCADE is not specified, the DROP command fails. To manually remove the notifier from DC table policies, use theSET_DATA_COLLECTOR_NOTIFY_POLICYfun...
table-space-nameTRIGGERtrigger-nameTRUSTED CONTEXTcontext-nameTYPEtype-nameRESTRICTVARIABLEvariable-nameRESTRICTVIEWview-namealias-name alias-designator: PUBLIC1 ALIASalias-name FOR TABLEFOR SEQUENCE Notes: 1 If PUBLIC is specified, FOR SEQUENCE must also be specified. parameter type: data-...
The owner of a view, owner of the schema of the view, users granted with the DROP permission on the view, or users granted with the DROP ANY TABLE permission can run the DROP VIEW command. When separation of duties is disabled, system administrators have this permission by default. Syntax...