using T-SQL 'alter table' script I need to alter the first column of MyTable so that it isn't and IDENTITY column.
The name of the column will not be known at runtime, but it will always be the first column (colid=1) and the only IDENTITY column in the table.

Many Thanks

The name of the column will not be known at runtime? Please expand.