Acceso a Checks

solusoft,

Puedes usar las vistas de sistema INFORMATION_SCHEMA.% para ver informacion
acerca del espquema de tu db.

select
a.TABLE_CATALOG,
a.TABLE_SCHEMA,
a.TABLE_NAME,
a.COLUMN_NAME,
a.CONSTRAINT_CATALOG,
a.CONSTRAINT_SCHEMA,
a.CONSTRAINT_NAME,
b.CHECK_CLAUSE
from
INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE as a
inner join
INFORMATION_SCHEMA.CHECK_CONSTRAINTS as b
on a.CONSTRAINT_CATALOG = b.CONSTRAINT_CATALOG
and a.CONSTRAINT_SCHEMA = b.CONSTRAINT_SCHEMA
and a.CONSTRAINT_NAME = b.CONSTRAINT_NAME
go

select
a.TABLE_CATALOG,
a.TABLE_SCHEMA,
a.TABLE_NAME,
a.CONSTRAINT_CATALOG,
a.CONSTRAINT_SCHEMA,
a.CONSTRAINT_NAME,
b.CHECK_CLAUSE
from
INFORMATION_SCHEMA.TABLE_CONSTRAINTS as a
inner join
INFORMATION_SCHEMA.CHECK_CONSTRAINTS as b
on a.CONSTRAINT_CATALOG = b.CONSTRAINT_CATALOG
and a.CONSTRAINT_SCHEMA = b.CONSTRAINT_SCHEMA
and a.CONSTRAINT_NAME = b.CONSTRAINT_NAME
where
a.CONSTRAINT_TYPE = 'CHECK'
go


AMB


"solusoft" wrote:

Hola a todos,

tengo una tabla que tiene Restricciones, y se crean así:

GO
ALTER TABLE [dbo].[GCL_C_DIC_DOM_N0] WITH CHECK ADD CHECK (([IT_DOM_N0] =
'E' or ([IT_DOM_N0] = 'I' or [IT_DOM_N0] = 'T')))
GO
ALTER TABLE [dbo].[GCL_C_DIC_DOM_N0] WITH CHECK ADD CHECK (([IT_LOCALIZA]
= 'N' or [IT_LOCALIZA] = 'S'))


Quisiera saber la forma de conocer los checks de una tabla, accediendo a
tablas de sistems o procedimientos sp_.

Gracias anticipadas, un saludo.