Hi,
I recently discovered the output clause for saving data into a history table. In a stored procedure, I do something like this:
if not exists {tablename}_history select top 0 * from {tablename} into {tablename}_history
delete from {tablename}
output deleted.*
into {tablename}_history
The problem is that {tablename} can have an identity column. Because I use this procedure for purging several tables, I want to add some code to remove the identity clause from the history table. SET IDENTITY INSERT is not an option, because that only works is you specify all columns (msg 8101).
Is there a statement to remove the identity clause for a column? something like 'alter table {tablename} alter column {columnname} drop identity' ???
Wilfred
The best things in life are the simple things