Oracle 9i Tutorial : Drop,Rename and Truncate table

DROP TABLE

  Remove rows and a table structure.
  Once executed, this statement cannot be rolled   back.
  -DROP TABLE EMPLOYEE

RENAME

  Rename a table, view, sequence, or synonym.
  -RENAME EMPLOYEE TO EMPL;

TRUNCATE

  Remove all rows from a table and release the   storage space used by the table.
  The DELETE statement removes only rows.
  -TRUNCATE TABLE EMPLOYEE;

Leave a Reply