|
DROP/TRUNCATE
DROP
DROP TABLE statement to remove a table and all its data from the Database.
Syntax ::
DROP TABLE <TABLE>
Example ::
TRUNCATE
TRUNCATE statement removes the data from a table without dropping the table.
Syntax ::
TRUNCATE TABLE <TABLE>
Example ::
Note ::
You cannot Rolback a TRUNCATE/DROP Statement.
|
