Monthly Archives: June 2012

SQL Server Select Table information

Today I am going to show you how do we obtain schema information in SQL Server 2005/2008. If you want to select all table names from a specific schema you need to use sys.tables and sys.schemas tables. For example I … Continue reading

Posted in Databases, Sql Server | Tagged , , , , , | Leave a comment

SQL Server Truncate All Table Data

Today I want to truncate ( delete all table data) in a large SQL Server database instance. Plain delete statements are not going to work as there is a big number of constraints which do not allow that. After quering … Continue reading

Posted in Databases, Sql Server | Tagged , , , , , , | Leave a comment