Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
Jul 16, 1999

Deleting Tables

Question:
Is there a SQL statement for deleting tables like there is for deleting data from tables? Something like: DELETE TABLE NAME or DROP TABLE NAME

Answer:
Yes indeed, Drop table

will do it. You need to know that if the table you are trying to drop has a relationship depending on where it is supplying its primary key as a foreign key into some other table, you may not be allowed to drop it without dropping the dependent table first.
DevX Pro
 
Submit a Tip Browse "Database Development" Tips Browse All Tips
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date