The name of all tables in the database. Sql query (ms sql)

Question

How can I get the name of all the tables in a specific database using a sql query?

Baka

13 2 bronze marks

|

1 answer 1

PashaPash ♦ PashaPash 42.4k 10 golden marks 64 silver marks 130 bronze marks · Accepted Answer · 2015-09-25T20:45:22

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

or

 SELECT * FROM sys.objects WHERE type='U'