SELECT 'DROP PROCEDURE [' + SCHEMA_NAME(p.schema_id) + '].[' + p.NAME + ']'
FROM sys.procedures p Tuesday, 26 July 2016
DROP PROCEDURE statements (all stored procedures delete Query generate)
Drop (delete) all tables In Database
Drop (delete) all tables In Database
exec sp_MSforeachtable 'DROP TABLE ?'
Subscribe to:
Posts (Atom)