Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
elango_t1
Starting Member
1 Post |
 Posted - 2002-06-28 : 13:33:49
|
| I am New to Database Admin:I made a copy of a table(table1) with over 10,000 records from database db1 to another database db2 and did some complex querying on table1 in db1. I unexpectedly erased data in a few columns. So i renamed this table(table1old)and imported table1 from the backup database db2. Now i find that table1 in database db1 has lost all dependency information when i click on Dispay Dependencies. Is it important for me to have all the dependency info and how do i recreate them. Thanks for any help. |
|
|
M.E.
Aged Yak Warrior
539 Posts |
Posted - 2002-07-02 : 10:35:44
|
| I'll assume you got MSSQL 7.0 or 2000 hereWhen you ask it to show all dependancies it's looking at tables that have foriegn keys relating to your table. If it's just for test purposes and your just running a few queries or that type of stuff, then don't worry about it (which it seems... you did accidentally delete a few columns). However, If your the DBadmin here I would really suggest that you get a few books and learn what relational databases are and what keys do.-----------------------Take my advice, I dare ya |
 |
|
|
|
|
|
Recreating dependency info for table