Create a primary key

[XX45]

l would like to run a health check on my newly designed database to ensure that l've covered all the necessary points to ensure that l have a good database. Is there there such a procedure?

If l want to create a primary key on a table with duplicates, how would l achive that? l tried to create a new table then create the pk. then ran the following script to populate

instert into tabB
select * distinct tabA

It did not work. Please advive

[Ray Miao]

You can't have duplicate value for pkey.


------------
XX45 at 5/28/2002 3:50:40 PM

l would like to run a health check on my newly designed database to ensure that l've covered all the necessary points to ensure that l have a good database. Is there there such a procedure?

If l want to create a primary key on a table with duplicates, how would l achive that? l tried to create a new table then create the pk. then ran the following script to populate

instert into tabB
select * distinct tabA

It did not work. Please advive