Tags » Teradata

Teradata common command

Check Teradata database version:
select * from dbc.dbcinfo;

Display column definition:
HELP TABLE ${table name}

Display create statement of the table:
SHOW TABLE ${table name}

Teradata

Teradata generate drop statements

Select ‘drop table ‘ || trim(databasename) || ‘.’ || tablename || ‘;’
From dbc.tablesV T

Where T.tablename like ‘%SWR_SPLIT_GROUP_HIST_%’
and databasename = ‘FAB_4_MSS_06_STG_TBL’;

//Please notice that we choose dbc.tablesV  because dbc.tables will trim table name which longer than 30 char

Teradata

Livres de lecture gratuits Teradata 14 Certification Study Guide - Database Administration by Eric Rivard (2014-08-02) en ligne


Vous cherchez place pour lire l’article complet E-Books Teradata 14 Certification Study Guide – Database Administration by Eric Rivard (2014-08-02) sans téléchargement? Ici vous pouvez lire La Liste de Schindler.
29 more words

Ligne

Livres de lecture gratuits Teradata 14 Certification Study Guide - Database Administration by Eric Rivard (2014-08-02) en ligne


Vous cherchez place pour lire l’article complet E-Books Teradata 14 Certification Study Guide – Database Administration by Eric Rivard (2014-08-02) sans téléchargement? Ici vous pouvez lire La Liste de Schindler.
29 more words

Ligne

Teradata acquires StackIQ

Teradata has announced acquisition of StackIQ. The deal will leverage StackIQ’s expertise in open-source software and large cluster provisioning to simplify and automate the deployment of Teradata Everywhere. 107 more words

Technology

Teradata Query Band

A query band for the current session or transaction.

From Akos example,
The values are reflected in the dbc.SessionfoX.QueryBand and the dbc.DBQLogtbl.QueryBand. The following example shows its content: 53 more words

Teradata

Teradata batch delete tables syntax

Background:
In Teradata, generate delete multible tables syntax.

SELECT ‘DROP TABLE ‘ || TRIM(DATABASENAME) || ‘.’ || TRIM(TABLENAME) || ‘;’
FROM DBC.TABLES
WHERE DATABASENAME=’table’s database’ 77 more words

Teradata