alter table problem
Posted on 2004-09-27
Is there a way from Sql Query Analyzer to loop through every table in a database and change a colum called "rowID" to be an identity column in each table? The column rowID already exists but was not designated as an identity column when it should have been.
I'm sure I'm looking for some kind of "alter table" statement, but can't quite get it to work.
Also -- I don't know how to "loop" through the list of tables.