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
Following SQL query gives you names of all the tables in the currently active database:
SELECT Name FROM Sys.Tables