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