From 5e45211a64149b3c659b90ff2de6fa982a5a93ed Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 14:17:33 +0200 Subject: Adding upstream version 15.5. Signed-off-by: Daniel Baumann --- doc/src/sgml/ref/drop_table.sgml | 129 +++++++++++++++++++++++++++++++++++++++ 1 file changed, 129 insertions(+) create mode 100644 doc/src/sgml/ref/drop_table.sgml (limited to 'doc/src/sgml/ref/drop_table.sgml') diff --git a/doc/src/sgml/ref/drop_table.sgml b/doc/src/sgml/ref/drop_table.sgml new file mode 100644 index 0000000..450458f --- /dev/null +++ b/doc/src/sgml/ref/drop_table.sgml @@ -0,0 +1,129 @@ + + + + + DROP TABLE + + + + DROP TABLE + 7 + SQL - Language Statements + + + + DROP TABLE + remove a table + + + + +DROP TABLE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ] + + + + + Description + + + DROP TABLE removes tables from the database. + Only the table owner, the schema owner, and superuser can drop a + table. To empty a table of rows + without destroying the table, use DELETE + or TRUNCATE. + + + + DROP TABLE always 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, CASCADE must be + specified. (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.) + + + + + Parameters + + + + IF EXISTS + + + Do not throw an error if the table does not exist. A notice is issued + in this case. + + + + + + name + + + The name (optionally schema-qualified) of the table to drop. + + + + + + CASCADE + + + Automatically drop objects that depend on the table (such as + views), + and in turn all objects that depend on those objects + (see ). + + + + + + RESTRICT + + + Refuse to drop the table if any objects depend on it. This is + the default. + + + + + + + + Examples + + + To destroy two tables, films and + distributors: + + +DROP TABLE films, distributors; + + + + + Compatibility + + + This command conforms to the SQL standard, except that the standard only + allows one table to be dropped per command, and apart from the + IF EXISTS option, which is a PostgreSQL + extension. + + + + + See Also + + + + + + + + -- cgit v1.2.3