Hi,
I have this issue, my SQL2k DB tables are not using SQL native
constrains and checks to implement tables relationship due to
the need to import legacy data.
In the meantime, I need to continue with my project. We need
a way to store all the table relationships between tables
in some table for my application to know the relationship.
In addition, we need to know when any of the columns value in the
tables changes, we need to know which tables will be affected
by these changes using the relationship design above. We need
some sort of impact analysis tools.
I though of implementing similar database design table like the SQL2k system
tables where it store all the table,columns and etc to implement my task.
Anyone got better way or know of any tool to do it. Please kindly
advise/guide me.
Thank you
Best Regards
Virusim