StackOverflow - pregunta 56857, Sql Server

Language: Layout:

-- tabla de prueba
CREATE TABLE TABLA_1 (
    Campo1 int not null identity(1,1) primary key,
    Campo2 varchar(40) default 'INDEFINIDO',
    Campo3 date default getdate(),
    Campo4 decimal(18,2)
)

CREATE TABLE TABLA_2 (
    Campo1 int not null identity(1,1) primary key,
    Campo2 int not null foreign key references TABLA_1(Campo1)
)
go

-- generar algunos registros (solo para verificación)
insert into TABLA_1 (Campo4) values (1800.23)
insert into TABLA_1 (Campo4) values (1231.80)
insert into TABLA_1 (Campo4) values (824.17)
insert into TABLA_1 (Campo4) values (408.53)

insert into TABLA_2 values (2)
insert into TABLA_2 values (3)

select * from TABLA_1
select * from TABLA_2
go

-- consulta de metadatos
SELECT
  o.name as [Tabla], o.crdate as [Fecha creación],
  c.colid as [ID campo], c.name as [Nombre campo],
  t.name as [Tipo campo], 
  c.length as [Tamaño], c.xprec as [Precisión], c.xscale as [Escala],
  CAST(c.isnullable as bit) as [Acepta nulos],
  ISNULL(i.is_primary_key, 0) as [Llave primaria],
  CAST(ISNULL(fk.referenced_column_id, 0) as bit) AS [Llave foránea],
  ISNULL(sm.text, '') as [Valor DEFAULT]
FROM sysobjects o
INNER JOIN syscolumns c ON o.id = c.id
INNER JOIN systypes t ON c.xusertype = t.xusertype
LEFT OUTER JOIN 
    sys.index_columns ic ON ic.object_id = o.id AND ic.column_id = c.colid
LEFT OUTER JOIN 
    sys.indexes i ON ic.object_id = i.object_id AND ic.index_id = i.index_id
LEFT OUTER JOIN
    sys.syscomments sm ON sm.id = c.cdefault
LEFT OUTER JOIN
    sys.foreign_key_columns fk ON fk.parent_object_id = o.id AND fk.parent_column_id = c.colid
--WHERE o.type = 'u'
WHERE o.name LIKE '%TABLA%'

View schema
Execution time: 0,16 sec, rows selected: 12, rows affected: 6, absolute service time: 0,33 sec