0 - 9 of 9 tags for alter table
ALTER STATEMENT - IF THE TABLE HAVE MORE THAN ONE BILLION RECORDS

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

By srinivas_teradata, 02 Sep 2016 | Tagged: alter ddl modify alter table | 1 comment
Error Dropping a Column in a TRANSACTIONTIME Table

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

By Win, 23 Mar 2016 | Tagged: temporal Temporal table TRANSACTIONTIME Table transactiontime NONTEMPORAL alter table DROP COLUMN | 1 comment
Syntax Not Working: "ALTER TABLE DROP CHECK;"

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

By Win, 28 Sep 2015 | Tagged: sql alter table DROP CHECK CONSTRAINT Errror Message | 4 comments
Renaming a Table in Aster

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.

By kseshasaisrivatsav, 28 Oct 2014 | Tagged: rename table alter table | 1 comment
Change columns order

How can i change the columns order on a table??
or
How can i insert a new column after other ??
 
sample
ALTER TABLE <TABLE.NAME> ADD COLUM <NAME.COLUMN> <DATA.TYPE> AFTER <NAME.COLUMN>
 
hope that i explain well

By Edo_Ram, 24 Jul 2013 | Tagged: alter table | 2 comments
Automated Alter Table

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

By Litics, 17 Jul 2013 | Tagged: alter alter table
Alter table to add column after specific column

Hi,

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,

Prabhakar.T

By Prabhakar Thangapandi, 02 Aug 2012 | Tagged: alter table after column | 5 comments
Where do the rows go?

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.

By PaulSinclair, 21 Mar 2012 | Tagged: database ppi partitioning drop alter table range_n add with delete with insert updates | 6 comments
Issue while adding identity to a column in Alter table

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:

CREATE TABLE TEST
(
TEST_ID INTEGER NOT NULL,
TEST_NAME VARCHAR(32)
) ;

alter table TEST

By c_h_thakar, 02 Jun 2011 | Tagged: identity alter table add column | 1 comment