Thursday 12 July 2012

Get Schema Name and Table Name - SQL Server

To get schema Name ;


SELECT SCHEMA_NAME(schema_id)
AS SchemaTable
FROM sys.tables
  
To get Table Name ;
 
SELECT name
AS SchemaTable
FROM sys.tables