Get List of Tables Existed from Current Database:

There are many ways to get All the Table from a Databases.

The following SQL Script helps to List the tables, which are all existsed in a current database

select * from sys.tables
select * from Information_Schema.tables
Select * from Sysobjects where xtype='U'

Hope it Helps!


Author: ketha11 Jun 2009 Member Level: Silver   Points : 1

-- For Getting all tables Information
select * from sys.objects where Type = 'u'
-- For Getting all Procedures
select * from sys.objects where Type = 'p'

  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name: