<< Any Idea why I get this error R>Alter Table Customer Add Primary Key (CustNub2) -ERROR- Column CUSTNUB2 must be declared explicitly NOT NULL. (2722) >>
For exactly the reason stated in the error message. Any column that participates in a primary key must be explicitly NOT NULL as part of its declaration. ALTER TABLE Customer ALTER COLUMN CustNub2 **INTEGER** NOT NULL (I'm assuming your field in integer -- you might have another datatype). This alter will fail if there are any NULL values in Customer.CustNub2. -- Larry
