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:
error
Posted in SQL   








Copyright © 2019 CodesJava DMCA.com Protection Status