Tutorialspoint examples

Learn java tutorial with examples for beginners online

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.

Related Topics:

How to build java project using ant in eclipse?
JAXB marshalling – convert java object to xml example.
How to create pdf file in java using iText jar?
Generics class example.
OGNL in struts 2.
Hibernate One-to-One Mapping using xml.
Send inline image in email using JavaMail API.
Quartz 2 JobListener example.

 

Copyright © 2017 Tutorialspoint examples DMCA.com Protection Status