![]() |
Hi,
02 Sep 2016
| 1 comment
,
|
![]() |
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
23 Mar 2016
| 1 comment
,
|
![]() |
The following SQL statement using this syntax failed after query execution:
28 Sep 2015
| 4 comments
,
|
![]() |
How to rename a table in Aster?
28 Oct 2014
| 1 comment
,
|
![]() |
How can i change the columns order on a table??
24 Jul 2013
| 2 comments
,
|
![]() |
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
17 Jul 2013
,
|
![]() |
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
02 Aug 2012
| 5 comments
,
|
![]() |
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
21 Mar 2012
| 6 comments
,
|
![]() |
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 alter table TEST
02 Jun 2011
| 1 comment
,
|