I was wondering if it is possible to alter an existing column through ALTER TABLE to be an identity column or can that only be done through adding a new column / creating a new table?

Jon