![]() |
![]() |
Free Books / Computers / Practical PostgreSQL / | ![]() |
|
![]() |
||||
![]() |
![]() |
|||
![]() |
![]() |
|||
![]() |
||||
|
|
||||
![]() |
![]() |
|||
![]() |
Destroying Tables with DROP TABLE |
![]() |
||
![]() |
||||
![]() |
![]() |
![]() |
||
![]() |
||||
This section is from the "Practical PostgreSQL" book, by John Worsley and Joshua Drake. Also available from Amazon: Practical PostgreSQL.
The SQL command to permanently destroy a table is DROP TABLE . The following is the syntax for DROP TABLE , where table is the table that you wish to destroy:
DROP TABLE table
Caution must be taken when dropping a table, as it destroys all data associated with the table as well.
|
Implicit Indices |
|---|---|
|
Destroying a table with an implicitly-created index will also destroy the index. |
 
Continue to:
postgresql, psql, relational database, sql, standard, query, programming, administration
![]() |
|
|