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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Keys Missing in Tables

Author  Topic 

shah429
Yak Posting Veteran

52 Posts

Posted - 2008-01-23 : 10:38:24
Hi everyone,
Our's is a sql server 2000 database. Just now I came to know that for some tables,
there are no keys defined. I think that this is not something normal. Please let me
know what will be the consequences of this. Thanks in advance

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2008-01-23 : 10:51:44
Well it should not matter if table has only few rows such as lookup tables. What is the average size of these tables in terms of number of rows?

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page

shah429
Yak Posting Veteran

52 Posts

Posted - 2008-01-23 : 12:41:00
Thanks for the reply Harsh,
One of the tables has 190557 rows. Please suggest.
Go to Top of Page
   

- Advertisement -