List all tables in a SQL database

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:

Comments

comments powered by Disqus