>>>>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.

I see. Thank you.