Altering a table by adding a primary key column

I haven't been able to find documentation on adding a column which is to be the primary key of the table.

I want to add a column ID which will be numeric, and should auto-increment. I need to populate it for existing records. Is there a datatype which autoincrements,  or must this be taken care of by a trigger?

Please suggest how I should accomplish this. I have EZSQL, but am a beginner in using it.

Thanks very much!
Bill Hutchison Received on Tue Jun 05 2001 - 15:45:45 CDT