Thursday, October 28, 2010

List all tables in SQL Server database

Following SQL query gives you names of all the tables in the currently active database:

SELECT Name FROM Sys.Tables

No comments: