Delete SQL statements for all stored procedures of a Database

--/Step 2 *********** Delete the foreign key constraints of all tables ******************* ******/

Declare C1 Cursor For
Select ' Alter table [ ' + Object_name (Parent_obj) + ' ] Drop constraint [ ' + Name + ' ]; '
From Sysobjects
Where Xtype = ' F '
Open C1
Declare @ C1 Varchar ( 8000 )
Fetch Next From C1 Into @ C1
While ( @ Fetch_status = 0 )
Begin
Exec ( @ C1 )
Fetch Next From C1 Into @ C1
End
Close C1
Deallocate C1

 

 

--/Step 2 *********************** **/

Use Database
Declare @ Tname Varchar ( 8000 )
Set @ Tname = ''
Select @ Tname = @ Tname + Name + ' , ' From Sysobjects Where Xtype = ' U '
Select @ Tname = ' Drop table ' + Left ( @ Tname , Len ( @ Tname ) - 1 )
Exec ( @ Tname )

 

 

--/Step 2 ************ delete all stored procedures ********************** ***/

Use Database
Declare @ Tname Varchar ( 8000 )
Set @ Tname = ''
Select @ Tname = @ Tname + Name + ' , ' From Sysobjects Where Xtype = ' P '
Select @ Tname = ' Drop procedure ' + Left ( @ Tname , Len ( @ Tname ) - 1 )
Exec ( @ Tname )