Click here to Skip to main content
15,881,882 members

Article Recommendation

Your Name:*
Your Email:*
Your friend's Email:*
The Message text:

Hi!,

This email was created by [MemberName] <[MemberEmail]> who thought you would be interested in the following Article:

"How to empty SQL Server 2005 database using cursor & sys.objects (Deleting All Tables, stored procedures, views & UDF’s)"
Understrading sys.objectsSys.objects is a system VIEW in SQL Server 2005, for each SQL database there is a separate sys.object view which gets stored within databse itself.Using Sys.objects returns list of all database objects and its types, type can be either of given below:DB OBJECT...

CodeProject also contains hundreds of articles, free source code samples and applications to help in your day to day programming. Why not give it a try!

 
Note: the details entered on this page will not be stored or used for any purpose other than for sending this email.