Here you have, no cursor needed: DECLARE @sql VARCHAR(MAX) = ” , @crlf VARCHAR(2) = CHAR(13) + CHAR(10) ; SELECT @sql = @sql + ‘DROP VIEW ‘ + QUOTENAME(SCHEMA_NAME(schema_id)) + ‘.’ + QUOTENAME(v.name) +’;’ + @crlf FROM sys.views v PRINT @sql; EXEC(@sql);
You can also delete all tables from database using only MSSMS UI tools (without using SQL script). Sometimes this way can be more comfortable (especially if it is performed occasionally) I do this step by step as follows: Select ‘Tables’ on the database tree (Object Explorer) Press F7 to open Object Explorer Details view In … Read more