Wednesday, May 18, 2011

SQL Tip: How to Select All Table Names in a Specific Database

The method provided below will give a listing all tables in a specific database and works in Microsoft SQL Server 2005, 2008 and up. Try it by creating a new query in Query Designer or SQL Server Management Studio (SSMS).