All for Joomla All for Webmasters

SQL DELETE DATABASE

You can easily remove or delete indexes, tables and databases with the DROP statement.

The DROP index statement is:

Used to delete index in the table

DROP INDEX SYNTAX for MS Access:

  1. DROP INDEX index_name ON table_name

DROP INDEX SYNTAX for MS SQL Server:

  1. DROP INDEX table_name.index_name

DROP INDEX syntax for DB2/Oracle:

  1. DROP INDEX index_name

DROP INDEX syntax for MySQL:

  1. ALTER TABLE table_name DROP INDEX index_name

DROP DATABASE Statement:

The drop database statement is used to delete a database.

  1. DROP DATABASE database_name

Note:

We should always note that in RDBMS, database name should be unique.

We should always remember that DROP database command may be the cause of loss of all information so we should always be careful while doing this operation.

PinIt
submit to reddit

Leave a Reply

Top