sql - How to retrieve the status of Foreign Key constraint? -
I have a SQL query to obtain all constraint name, but it is not sure that the position of how it enable / disable?
SELECT OBJECT_NAME (Obijeisiaidiaidi) AS Nemf conference, SCHEMA_NAME (Skima_aidi) AS schema, Obijeianet (Perent_objekt_aidi) AS Teblnam as, Taip_desk S Badhytaprkar,
from * sys.objects < / pre>Any help?
OBJECTPROPERTY (OBJECT_ID ( 'FK_foo_bar', 'CnstIsDisabled')
oR
use the column "is_disabled"
Comments
Post a Comment