Browse by Tags

How to drop all tables, all views, and all stored procedures from a SQL Server 2005 Database?

Published 20 May 8 3:12 AM | SSQA.net

It may not be a hardcore requirement on day-to-day basis to drop all tables, views and stored procedures from a SQL Server database within your environment, but it will be handy to have such a code at your end when such task is required. There are 2 ways...

Filed under: sql server, backup, table, drop, stored procedure, tsql, best practice, views

Ways to make best use of INFORMATION_SCHEMA Views - Stored procedures & Functions?

Published 15 October 7 7:59 AM | SSQA.net

How many of you took help from using INFORMATION_SCHEMA views in SQL Server? Have you ever wondered in returning the informaiton of a Stored procedure or function, you may be thinking using SP_HELPTEXT would get you. Parts of the solution is yes with...

Filed under: sql server, function, system, stored procedure, tsql, best practice, information schema, views, triggers