| Referential Intergrity and Data Warehousing [message #93150] |
Mon, 24 March 2003 05:17  |
McF
Messages: 1
Registered: March 2003
|
Junior Member |
|
|
Hi,
I want to archive / store offline in a spererate location, the contents of a large table in my database.
I have noticed that it has relationships with a number of other tables - however,I need to know 2 things :
1.If i remove the contents of this table, will it have an effect on the other tables and therefore the integrity of the data
2.Can anyone reccommend a graphical tool for viewing the relationships between tables
3.The best way to archive / store this data
Many thanks in advance
|
|
|
|
| Re: Referential Intergrity and Data Warehousing [message #93159 is a reply to message #93150] |
Thu, 24 April 2003 16:33  |
Lars Sjöström
Messages: 24
Registered: June 2001
|
Junior Member |
|
|
If you remove the table and there are related data it will surely effect integrity.
Toad is a good tool for reviewing relationships between tables. You can reengineer the data model if, and only if, there are constraints in the database.
The best way to archive / store data I do not know. Sorry.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
