August 24, 2005 at 6:50 am
When you are designing a table and use the manage relationships, under the relationships tab in the properties box there are three check boxes. Two of these are 'Enforce relationships for replication' and 'Enforce relationship for inserts and updates'. The latter one has two further check boxes under it for cascading updates and deletes. I can find setting those last two check boxes in the system tables but I cannot find the settings for the two 'Enforce relationship' check boxes. Does anyone know where I can find the settings for those in the system tables.
Robert T Turner
August 25, 2005 at 3:09 pm
I could be wrong but I think that information is in the Sysdepends table in the Master database. Try the link below for SQL Server System Tables. Hope this helps.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sys_00_690z.asp
Kind regards,
Gift Peddie
Kind regards,
Gift Peddie
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply