How to empty SQL Server 2005 database using cursor & sys.objects (Deleting All Tables, stored procedures, views & UDF’s)

VDmitrovsky

Rate me:

5.00/5 (1 vote)

30 Sep 2011CPOL

6.2K

1) You cann't drop any object in schemas other than dbo, so you MUST use sys.schemas system view properly.2) You cann't drop tables even in dbo schema if they are referenced by other ones, not dropped so far. Drop all FKs before tables.dva

1) You cann't drop any object in schemas other than dbo, so you MUST
use sys.schemas system view properly.

2) You cann't drop tables even in dbo schema if they are referenced
by other ones, not dropped so far. Drop all FKs before tables.

dva

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

VDmitrovsky

Russian Federation

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

How to empty SQL Server 2005 database using cursor & sys.objects (Deleting All Tables, stored procedures, views & UDF’s)

License

Comments and Discussions