This is my next approach--I got rid of all indexes and PK's, and then created an index with unique after everything is added. Wish me luck. W --- Stephan Szabo <[EMAIL PROTECTED]> wrote: > > We don't currently support the SQL syntax for adding > a PK to a table. However, if you have the columns > as NOT NULL already, adding a unique index to the > columns in question has the same general effect. > > Stephan Szabo > [EMAIL PROTECTED] > > On Tue, 29 Aug 2000, Webb Sprague wrote: > > > Apropos of my last question: > > > > Is there syntax to create a primary key after the > > table has been defined and populated? I think I > could > > speed things up quite a bit by not having any > indexes > > at all when I do my mass copies. > __________________________________________________ Do You Yahoo!? Yahoo! Mail - Free email you can access from anywhere! http://mail.yahoo.com/