List all tables in a SQL database

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