How to Get The List Of All Tables in a Database – Sql Server 2005

Home > Sql Server > How to Get The List Of All Tables in a Database – Sql Server 2005

June 22nd, 2009 joy Leave a comment Go to comments

We a can get the list of all tables of a database in different ways : -

SELECT *
FROM sys.TABLES

SELECT *
FROM sysobjects
WHERE TYPE='U'

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

Popularity: 2% [?]

Categories: Sql Server Tags: sql

ForDevs