Is their any way to get the check constraint definition in sybase. I have already managed to get the constraint id, constraint name from the system tables. But after exploring the tables I haven't found any relationship between in the system tables to get the constraint definition. Well my actual req. is to edit the columns with the encrypted values which may not satisfy the check constraints. Since the sybase doesn't support the disabling of check constraints so I am now droping the constraints, update the table and then put the same constraints back. Now I need a approach to get the definition of constraints so that I can store them temporarily.
Since I am quite new to database so if u found my approach wrong then please suggest me the correct apporoach.
I have tried to use the stored procedures, but i got an error Transact-SQL not supported with ODBC. Actually i am using ODBC connection with db.
So I get the constraint information from SYSCHECK system table. Till now it seems to be worked fine. But I not sure whether my approach is correct or not as I am collecting all the meta data from system tables instead of using stored procedures and functions.