Click here to Skip to main content
Search within:



Articles by VDmitrovsky (Tip/Trick: 1)

Tip/Trick: 1

RSS Feed
No articles have been posted.
No blogs have been submitted.

Average tips rating: 5.00

Database

How to empty SQL Server 2005 database using cursor & sys.objects (Deleting All Tables, stored procedures, views & UDF’s) [Tip/Trick]
Posted: 24 Feb 2010   Updated: 30 Sep 2011   Views: 882   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 0
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

VDmitrovsky
Russian Federation Russian Federation
Member
No Biography provided


Advertise | Privacy | Mobile
Web02 | 2.6.130523.1 | Last Updated 25 May 2013
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid