SQL DROP TABLE

SQL DROP TABLE: 
                               This statement is used to delete a table definition and all data from a                                    table.


Syntax:

 DROP TABLE "table_name";  


EX:
  for example already we have one table ,employee table. if we want delete that table just use DROP statement.


SQL>DROP TABLE STUDENTS;  

Comments

Post a Comment

Popular posts from this blog

Difference between DROP,TRUNCATE and DELETE

The difference between TRUNCATE , DELETE and DROP   TRUNCATE TRUNCATE is a DDL command TRUNCATE is executed using a table lock and whole table is locked for remove all records. We cannot use Where clause with TRUNCATE. TRUNCATE removes all rows from a table. Minimal logging in transaction log, so it is performance wise faster. TRUNCATE TABLE removes the data by deallocating the data pages used to store the table data and records only the page deallocations in the transaction log. Identify column is reset to its seed value if table contains any identity column. To use Truncate on a table you need at least ALTER permission on the table. Truncate uses the less transaction space than Delete statement. Truncate cannot be used with indexed views. DELETE DELETE is a DML command. DELETE is executed using a row lock, each row in the table is locked for deletion. We can use where clause with DELETE to filter ...
Read more