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.
Subscribe to:
Post Comments (Atom)
-
Inner Join Inner join is the most common type of Join which is used to combine the rows from two tables and create a result set contai...
No comments:
Post a Comment