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.
Thursday, March 8, 2012
Check Constraint configuration
Labels:
check-constraint,
column,
configuration,
configurations,
constraint,
database,
limit,
microsoft,
mysql,
oracle,
server,
sql,
store,
table,
value
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment