SQL Server 2008 - Show All Tables

Question

I'm a Junior Programmer But I need help with a query How do I execute a query showing all tables in a Database ??

`information_schema.tables`, for all tables with some kind off access privilege. — jarlh, Apr 25 '17 at 07:38
Welcome! put your code example that what you try for. and visit link **[How to Ask](http://stackoverflow.com/help/mcve)** — Zaheer Ul Hassan, Apr 25 '17 at 07:40

score 1 · Answer 1 · answered Apr 25 '17 at 07:42

1

Please try this. It will give you a list of tables except view.

SELECT TABLE_NAME FROM information_schema.tables WHERE TABLE_TYPE = 'BASE TABLE'

answered Apr 25 '17 at 07:42

Rajan

what is information_schema.tables ? and BASE TABLE ? – Eric Sebastian Apr 26 '17 at 01:52
Its a view and you can refer this link for more info. https://learn.microsoft.com/en-us/sql/relational-databases/system-information-schema-views/system-information-schema-views-transact-sql – Rajan Apr 26 '17 at 05:16

score 1 · Answer 2 · answered Apr 25 '17 at 07:44

1

Here is the full name of a table with the schema and table well formatted usable in a query.

SELECT QUOTENAME(TABLE_SCHEMA)+'.'+QUOTENAME(TABLE_NAME)
FROM information_schema.tables
WHERE TABLE_TYPE = 'BASE TABLE'

answered Apr 25 '17 at 07:44

Hybris95

2 Answers2