0 - 20 of 20 tags for create table
--create table 
CREATE SET TABLE database.table,
 NO FALLBACK ,
 NO BEFORE JOURNAL,
 NO AFTER JOURNAL,
 CHECKSUM = DEFAULT,
 DEFAULT MERGEBLOCKRATIO
 (
        some columns...,
 unique_number_10_digits CHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL
 )
PRIMARY INDEX( unique_number_10_digits );

--inserts

When I run the create statement got this error. I know that table name or column name should be less than 30 characters.
But the question is why its "more than 30 bytes in LATIN INTERNAL FORM"? What this statement means? This 30 bytes denotes table name or column name or something else?

I'm trying to create a table, using a SELECT state, but that also has the LOAD_USER and LOAD_DATE with defaults to CURRENT_USER and CURRENT_TIMESTAMP.  If I was creating the table, then adding the data, the text for the two fields would be;

ADD LOAD_USER2 CHAR(20) CHARACTER SET LATIN CASESPECIFIC DEFAULT USER,

Hi Experts,
I am unable to create a table with JSON datatype column. My TD version is 14.0.0.1

CREATE volatile TABLE my_table (eno INTEGER, edata JSON(100)) on commit preserve rows;

Error:
---------------------------

Teradata SQL Assistant

---------------------------

Hi all,
I am trying to create a table for the results of my select query as I need to run some analysis on them.
The select ran and I have around 60k rows in the result. When I try to create a table, it provides me with error 3706.
 
Can you please help?
 
Thanks,
Dieter

Hi ,
Could someone help me with the following. Since I have the create table option within the macro, I need to change the tablename everytime I execute this macro with different parameters.
Is there a way around it? without having to change the table name everytime I execute this macro.
 

Hi everyone,
 
Im trying to create a table but when try to run it, it says:  
EXPLAIN Failed.  [3707] Syntax error, expected something like a 'CHECK' keyword between ',' and the 'SUM' keyword.
Is there someone out there who knows what this might mean?

Hi everyone,
 
I'm pretty green at this field but I have to create a table from a select statement i've made and it has to be done though a
stored procedure.
 
I'm wondering if someone nows any good ToDo-guides I can use. I have no experience so far regarding what the key stones are in

Hi All!
We can not create a table adding a column DATE that has lenght(8) using FORMAT (YYYYMMDD) and default value '00010101'.
Nir 20010101 nor 20000101 default values are not working.
currently We are running the DDL USING:
FEC_INFORMACION        DATE           FORMAT 'YYYYMMDD' NOT NULL DEFAULT DATE '0001-01-01'

Get a quick start on Teradata Studio and Teradata Studio Express with these usage videos. The overview and connection videos apply to both Teradata Studio and Teradata Studio Express. The others apply to Teradata Studio only: Create Database, Create Table, Move Space, Smart Loader, Copy Objects, and Transfer Data.

Anyone could explain what this error means? Thanks!

Hi all,
PLZ look into this query
Create table ptemp.ateds as (
select a.ACCT_I,a.Open_D, a.Clse_D, year(a.clse_d) - year(a.open_d) as dte from pvdata.acct_base as a having a.open_d != null and year(a.Open_D) != 1111 and a.ACCT_I like '%SAV%' order by a.open_d desc) with data

I am trying to put into a table the output from a previous query (saved as a volatile table).  I am creating a new table PROC_STATS to hold the output and then using INSERT INTO followed by a SELECT query to get the data inot PROC_STATS.  When I run the code in SQL Assistant, I get a message that 1 row was returned, which is the correct value.  However, w

Hi All
I want to understand if there will be a difference in performace or on any front between
Any inputs will be of a great help. I am dealing with huge fact tables and many volatile tables to be created in a stored procedure.
 

Hello,
 
Thank you in advance for your time.
I want to create a table with the same structure as an existing one.
The problem with the create table command , is that it does take under consideration foreign keys (for my case).
(

Hi,

I am trying to create a procedure that contains a while loop to continuously run several updates/drop tables/create tables based on some conditions that are calculated at the end. If the conditions (based on the last tables that are created) are not met, the loop continues to run.

The following information covers a handful of the basics of the Teradata architecture, to help new Teradata users better understand what considerations should go into creating a table.

Hey,

Anyone know how to create a table using a view (Structure & Data)?

Also, is there anyway to retrieve the DDL for the tables or views we have access to?

Thanks,

-Ayyad

The purpose of the new Teradata 13.0 feature that allows you to create tables with no primary index is improved performance of FastLoad and Teradata Parallel Data Pump Array INSERT data loading operations.