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