List all tables in a SQL database
February 14, 2012
SQL
Snippet
Need to list which tables exists in your database? Then this will do the trick:
select
table_name
as
Name
from
INFORMATION_SCHEMA.Tables
where
TABLE_TYPE =
'BASE TABLE'
Related posts:
Get version info from SQL backup
Sync user and login for SQL database
Access: Unmatched query for more than one field
Exporting SQL Server data to script
ASP.NET Identity for Data Access sample