Showing posts with label configurations. Show all posts
Showing posts with label configurations. Show all posts

Thursday, March 8, 2012

Check Constraint configuration

Hi all,
Where does SQL 2000 store all check-constraint configurations? i.e. I have a column in a table which I would like to limit the value to be > 10. Would like to retrieve the info via a client program.
Thanks
regards,
tswernall the constrainsts are saved in the table sysconstratints|||looked into sysconstraints table. seems like it does not contain any rules I specified for my check contraint column. Only have a number of ids. Any idea which tables these ids tie to the actual check constraint configuration?|||you might find this useful|||Thanks paul! Indeed it is very usefull.|||Thanks paul! Indeed it is very usefull.