I am trying to find out all the foreign keys declared in my database along with the attributes of each key, for example is there a delete or update action defined for that key, etc. if I can some how get the script that defines these keys that would be even better. Is there a way to do that? |
If you can unload the full schema for the database, that will provide the statements used to create tables, foreign keys, etc. This can be done with dbunload -n. Otherwise, you may be able to piece the information together from certain systems views: @Tyson: that link didn't work for me, I had to change it to this one:
(24 Jan '13, 03:28)
Reimer Pods
Replies hidden
1
Tyson lives inside the Golden Palace where all things are possible :)
(24 Jan '13, 11:04)
Breck Carter
Ah, yes, that would be an oversight on my part. I have a DNS suffix for .sybase.com configured on my machine, and occasionally forget that when I link to a page. I've edited my answer to include the full domain name.
(24 Jan '13, 12:21)
Tyson Lewis
|