0 - 9 of 9 tags for alter table

I am Altering the table for addition of new columns. And tables is having more than 1 billion records.
Please let us know is it standard to alter the table with more than one billion records or not. Also guide us in best practise to alter the table with data.

Using Teradata Database 14.0.5 in a Virtual Machine and testing the following steps specified in a reference document, "Temporal Table Support" (Release 14.0) page 36 "Converting Period or DateTime Columns to a Transaction-Time Column", an error was encountered in an ALTER TABLE step to DROP the old PERIOD column: (Is there a missing step that will preven

The following SQL statement using this syntax failed after query execution:

How to rename a table in Aster?
if you are in a schema = ABC, but the search path schema does not have ABC, then it might be challenging to rename the table in schema ABC.

How can i change the columns order on a table??
How can i insert a new column after other ??
hope that i explain well

I’m trying to create a process which will take a Point-in-time / Snap Shot table and copy it into a Historical table.  Inserting the records is not a problem but because we do not ‘own’ the table there is a chance(and likely) new columns will be added to my source table.  I’ve tried to come up with a process to compare to Source and Target table and if th


I have to add a new column into an existing table.

Is there a way to add a column after a specific column name. For example, my table has 20 columns and i have to add a column after the 10th column. Can someone tell the syntax for doing this ?

Your help is much appreciated. 


Thank you,


With row partitioning (for a PPI or column-partitioned table), the Teradata Database makes sure rows are placed in their appropriate partitions.  When the row partitioning for the table is altered, rows may need to move from one partition to another so they are in their appropriate partitions according to the altered partitioning.  The partitioning expression must be deterministic (always computes the same value for the same value of the partitioning column) to properly place and retrieve the row.

For instance if the table has RANGE_N partitioning, ALTER TABLE will move rows automatically from NO RANGE to newly-added ranges as needed.  Also, if a range is dropped, rows from that partition are moved to the NO RANGE, NO RANGE OR UNKNOWN partition or a newly-added range that covers the dropped range.

Hi everyone,

I’m facing a problem with auto-increment/identity feature in Teradata table. I already had a table in solution without identity feature, but as the requirements changed, I have to modify/alter that column from integer data type to integer data type with identity feature, but somehow it’s not allowing me to do that. I’m not sure whether Teradata support it or not.

I had tried different approaches suggested by people over the internet.

Sample Code:

) ;

alter table TEST