Sunday, August 2, 2015

SQL Tutorial - Lesson 22 - Drop table,Drop Index and Drop Database

If you want to drop the table then you use drop table.

Syntax:

Drop table table name;

If you want to drop index in a table then you use drop index

Syntax:

Drop index tablename.indexname;

and lastly if you want to drop a database then you use drop database

Syntax:

Drop database databasename;



No comments:

Post a Comment