CodesJava

Easy learning with example program codes

SQL DROP Table


The DROP TABLE statement is used to delete an existing table definition, indexes, constraints, access privileges and all associated data.

Note: When a table is deleted all the available information in the table will be lost, so use it carefully.

Syntax:
DROP TABLE tableName;  

Example:

DROP TABLE EMPLOYEE;

Output:

Table dropped.

 
Next Topic: SQL DELETE from table with example.
Previous Topic: SQL RENAME Table with example.

 

Please follow and like us:
Posted in SQL   


Copyright © 2019 CodesJava DMCA.com Protection Status SiteMap Reference: Java Wiki