Get All Tables Detail of Database

Ranjeet_8
Posted by Ranjeet_8 under Sql Server category on | Points: 40 | Views : 1096
Select all the tables (user created) in the database

USE Your_DataBase_Name
GO
SELECT *
FROM sys.Tables
GO

Comments or Responses

Posted by: Srilu.Nayini577 on: 8/14/2012 Level:Starter | Status: [Member] | Points: 10
to get all table details:
------------------------------
use databasename;

select * from sys.Tables

To get list of all user defined table details:
-----------------------------------------------------------
select * from sysobjects where xtype='u'



Login to post response