文件名称:丢弃一个表-SQL语言基础
文件大小:5.26MB
文件格式:PPT
更新时间:2024-05-15 13:25:09
SQL 基础
丢弃一个表 * SQL> DROP TABLE dept30; Table dropped. 表中所有的数据和结构都被删除了. 所有未决的事务都被提交. 此表上所有的索引全部被删除. 这个操作是不能回滚的. * Informix中只有drop table;无法回滚。 Dropping a Table The DROP TABLE statement removes the definition of an Oracle8 table. When you drop a table, the database loses all the data in the table and all the indexes associated with it. Syntax where: table is the name of the table Guidelines All data is deleted from the table. Any views and synonyms will remain but are invalid. Any pending transactions are committed. Only the creator of the table or a user with the DROP ANY TABLE privilege can remove a table. The DROP TABLE statement, once executed, is irreversible. The Oracle Server does not question the action when you issue the DROP TABLE statement. If you own that table or have a high-level privilege, then the table is immediately removed. All DDL statements issue a commit, therefore making the transaction permanent. DROP TABLE table;