SQL Drop Index, Table and Database
Drop Index
You can delete an existing index in a table with the DROP INDEX statement.
Syntax for Microsoft SQLJet (and Microsoft Access):
DROP INDEX index_name ON table_name
|
Syntax for MS SQL Server:
DROP INDEX table_name.index_name
|
Syntax for IBM DB2 and Oracle:
Syntax for MySQL:
ALTER TABLE table_name DROP INDEX index_name
|
Delete a Table or Database
To delete a table (the table
structure, attributes, and indexes will also be deleted):
To delete a database:
DROP DATABASE database_name
|
Truncate a Table
What if we only want to get rid of the data inside a table, and not the table
itself? Use the TRUNCATE TABLE command (deletes only the data inside the table):
TRUNCATE TABLE table_name
|
Want To Be A Web Master?
If you want to be a Web Master, you will have to host your web site with an ISP (Internet Service Provider).
MaximumASP offers seven different configurations of dedicated servers to meet your Windows and .NET hosting needs.
Hosted on our multi-tiered Enterprise Class network, these servers provide the performance, security and reliability
you need to host your high end web sites and applications.
Visit MaximumASP
|