..


Sponsored Links

DROP

The DROP statement of the 'SQL DDL deletes the specified element, or a table, view or index.

The syntax is as follows: 

 



 DROP ELEMENT nome_elemento
ELEMENT which is represented by the keywords "TABLE", "VIEW" or "INDEX", depending on the item, in fact, be deleted.

The following code clears the table "books": 
 



 DROP TABLE books
The following code deletes the view "books": 
 



 DROP VIEW books
The following code deletes the index "books": 
 



 DROP INDEX books
Warning: deleted items, and related data, are not recoverable in any way!

In the same category ...
E-Learning
MS Access (Advanced) MS Access (Advanced)
Learn how to create and manage databases quickly and easily. Starting from 29 €.
MySQL (Course) MySQL (Course)
Management of open-source database. From 39 €.
SQL and Database (Course) SQL and Database (Course)
Create and manage relational databases. From 39 €.
Sponsored Links