you are at Encyclopedia of SQL >> DROP
DROP
With DROP we are able to remove indexes, tables, databasesSyntax for removing index from table
MySQL
ALTER TABLE `table_name`
DROP INDEX index_name
MS Access
DROP INDEX index_name
ON `table_name`
MS SQL Server
DROP INDEX `table_name`.index_name
DB2/Oracle
DROP INDEX index_name
Syntax for removing table
DROP TABLE `table_name`
Syntax for deleting database
DROP DATABASE `database_name`
WHERE without condition causes deleting of all record.
Example
Delete `people` table
query
DROP TABLE `people`
[ wróć na górę strony ]