>>>I do have a PK which is an Identity column. So, I suppose, after I rename the table, I can set the Identity again.
>>>I will have to test this concept.
>>>Thank you.
>>
>>You can try:
>>
>>1. In SSMS right click on the table and select 'Script as create'
>>2. In that script change names to use new names
>>3. SET IDENTITY INSERT OFF
>>4. insert into NewTable (list all columns)
>> select list All Columns from myTable
>>
>>--- This is assuming you don't use some advanced features such as temporal table
>>
>>Once you're ready to get back you would also need to use
>>
>>DBCC CHECKIDENT ('MyTable', RESEED, MaxCurrentValue);
>>
>>(
https://stackoverflow.com/questions/21824478/reset-identity-seed-after-deleting-records-in-sql-server)
>
>Thank you for the suggestion. I wish the item 4. (above) would accept the "*" instead of listing all fields.
>I will check this article.
It will (with SET IDENTITY INSERT OFF). I just prefer to be more verbose / explicit.
If it's not broken, fix it until it is.
My Blog