SQL Server Information and Resources Bookmark this page

SQLINFO.net is a Community Service from DataExpressions makers of dbOrchestra©

Google
 

 

 

 


SQL Server Examples

SQL DML

String Functions

Stored Procedures

SQL Views

SQL Table Basics


SQL Server - SQL Table Basics - Drop Table

Drop table

Of course, be careful using this function.

drop table person
GO

Note: You cannot drop a table that is referenced by a foreign key constraint. This is a very good thing. So, in the above example the only way to drop the person table would be to also drop the address table and the phone table.

 



Copyright 2006-2007 by DataExpressions --- All Rights Reserved            dbOrchestra - SQL Server home page