Monday, 18 March 2013

How to delete all view of database .




 I am explaining this with concept of  Dynamic sql .

DECLARE @sql VARCHAR(MAX)='';
SELECT @sql=@sql+'DROP VIEW '+name +';' FROM sys.views;
EXEC(@sql);

It will delete all view of your database.

at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)
  • Graphical Query Plan
    When SQL Server executes a query it uses a query plan to determine how to access data and complete the query.  SQL Server offers DBAs and d...
  • SQL Tuning or SQL Optimization
     SQL Tuning or SQL Optimization Sql Statements are used to retrieve data from the database. We can get same results by writing different ...

First Database In Sql Server