sql drop

SQL Advance

homeBack

Next

SQL DROP

  • SQL DROP INDEX, DROP TABLE, and DROP DATABASE

    Indexes, tables, and databases can easily be deleted/removed with the DROP statement.

  • The DROP INDEX Statement

    The DROP INDEX statement is used to delete an index in a table.

    DROP INDEX Syntax for MS Access:

    DROP INDEX index_name ON table_name

    DROP INDEX Syntax for MS SQL Server:

    DROP INDEX table_name.index_name

    DROP INDEX Syntax for DB2/Oracle:

    DROP INDEX index_name

    DROP INDEX Syntax for MySQL:

    ALTER TABLE table_name DROP INDEX index_name

  • The DROP TABLE Statement

    The DROP TABLE statement is used to delete a table.

    DROP TABLE table_name

  • The DROP DATABASE Statement

    The DROP DATABASE statement is used to delete a database.

    DROP DATABASE database_name

  • The TRUNCATE TABLE Statement

    What if we only want to delete the data inside the table, and not the table itself?

    Then, use the TRUNCATE TABLE statement:

    TRUNCATE TABLE table_name

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s