select query
how to list names of tables in a database through select query?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
urmila guptaPosted Sep 13, 2012, 7:23 AM
Sukesh MarlaPosted Sep 8, 2012, 11:44 AM
GO
SELECT *
FROM sys.Tables
GO
select * from sysobjects where xtype='u'
SELECT *
FROM information_schema.Tables
Check this is correct answer if it helped.
SaleemThuvvurPosted Sep 8, 2012, 5:53 AM