Schema's On a Database

/*************************************************

SCHEMA ON DB

***************************************************/

SELECT '['+SCHEMA_NAME(schema_id)+'].['+name+']'

AS SchemaTable

FROM sys.tables

select  c.name as colomn_name , t.name as table_name , s.name as schema_name

 from sys.columns c

   inner join  sys.tables t     on c.object_id=t.object_id

   INNER JOIN sys.schemas AS s  ON t.[schema_id] = s.[schema_id]

   SELECT schema_name, schema_owner

FROM information_schema.schemata