Browse by Tags

All Tags » sql server » table   (RSS)
How to drop all tables, all views, and all stored procedures from a SQL Server 2005 Database?
20 May 08 01:12 AM | SQL Master | 2 Comments   
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 Read More...
TSQL to change collation of database, whats new in SQL 2008 then?
12 March 08 11:24 AM | SQL Master | 3 Comments   
Cross post from my BlogCasts site. Read More...
Different ways to know structure of a table
28 February 08 01:51 AM | Madhivanan | 3 Comments   
You can use one of the following to know the structure of a table 1 Generate SQL Script option from Enterprise Manager/Management Studio 2 select * from information_schema.columns where table_name='table_name' 3 EXEC sp_help 'table_name' 4 EXEC sp_columns Read More...
SQL Server 2005 TSQL to obtain buffers by object (table, index) in the buffer cache?
01 February 08 05:30 AM | SQL Master | 2 Comments   
As a programmer interacting with SQL Server's cache is not often needed, but when you do need to determine what is going on with the cache, or you simply need to flush the execution plans or data pages to tune a query, you now have the means to do so. Read More...