SQL Server deletes all tables, views, stored procedures

This article from: http://www.cnblogs.com/yjss/articles/2065664.html

1. Delete a table

Use database name declare mycur cursor local for SELECT [name] from dbo.sysobjects where xtype= ' U ' declare @name varchar OPEN my Cur fetch NEXT from mycur to @name while @ @FETCH_STATUS = 0  beginexec (' drop table ' + @name) FETCH next from Mycur in To @nameEND CLOSE mycur

2. Delete a view

Use database name declare mycur cursor local for SELECT [name] from dbo.sysobjects where xtype= ' V ' declare @name varchar OPEN my Cur fetch NEXT from mycur to @name while @ @FETCH_STATUS = 0  beginexec (' drop VIEW ' + @name) FETCH next from Mycur int o @nameEND CLOSE mycur

3. Delete a stored procedure

Use database name declare mycur cursor local for SELECT [name] from dbo.sysobjects where xtype= ' P ' declare @name varchar OPEN my Cur fetch NEXT from mycur to @name while @ @FETCH_STATUS = 0  beginexec (' drop PROCEDURE ' + @name) FETCH next from Mycu R into @nameEND CLOSE mycur

　　

SQL Server deletes all tables, views, stored procedures