copy/backup table

Database
Enthusiast

copy/backup table

I want to copy/backup an entire table with a different name so i can make some updates and test those changes on my version of the table.

Can you please provide help on how to do this?

Best Regards

Amadu

2 REPLIES
Senior Supporter

Re: copy/backup table

copy or backup?

on the same server? create table mydb.myname as source_db.source_table with data and stats;  

would create a copy of the table with a different name on the same server.

On a different server - check teradata studio for smaller tables.

Enthusiast

Re: copy/backup table

Hi Ulrich -  Yes its on the same server.

Thank you for your help.

Alls good with your help.