Whoops -- It didn't delete the table -- it is there twice If I list the table, it lists all the columns and the total no. of rows = 2 Then it continues to list it again and the total no. of rows is 6 (my original count). sel * from tablename and it only lists the 2 rows I entered after removing the primary key.
So where am I now? Bernie Lis ----- Original Message ----- From: "Bernard Lis" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Monday, July 26, 2004 12:42 AM Subject: [RBG7-L] - Primary key > I just removed a primary key from a table and it deleted all the rows in > that table. > Is this my imagination or is it expected behavior? > > Bernie Lis > >
