ABBREVIATIONS IN TERADATA

Share via:
ABBREVIATIONS IN TERADATA

Dear Readers,

In this article, we will discuss ABBREVIATIONS IN TERADATA

AccessRight Column

Value Description
AE ALTER EXTERNAL PROCEDURE
AF ALTER FUNCTION
AP ALTER PROCEDURE
AS ABORT SESSION
CA CREATE AUTHORIZATION
CD CREATE DATABASE
CE CREATE EXTERNAL PROCEDURE
CF CREATE FUNCTION
CG CREATE TRIGGER
CM CREATE MACRO
CO CREATE PROFILE
CP CHECKPOINT
CR CREATE ROLE
CS CREATE SERVER
CT CREATE TABLE
CU CREATE USER
CV CREATE VIEW
CZ CREATE ZONE
C1 CREATE DATASET SCHEMA
D DELETE
DA DROP AUTHORIZATION
DD DROP DATABASE
DF DROP FUNCTION
DG DROP TRIGGER
DM DROP MACRO
DO DROP PROFILE
DP DUMP
DR DROP ROLE
DS DROP SERVER
DT DROP TABLE
DU DROP USER
DV DROP VIEW
DZ DROP ZONE
D1 DROP DATASET SCHEMA
E EXECUTE (MACRO)
EF EXECUTE FUNCTION
GC CREATE GLOP
GD DROP GLOP
GM GLOP MEMBER
I INSERT
IX INDEX
MC CREATE MAP
MD DROP MAP
MR MONITOR RESOURCE
MS MONITOR SESSION
NT NONTEMPORAL
OA OVERRIDE DUMP
OD OVERRIDE DELETE POLICY
OI OVERRIDE INSERT POLICY
OP CREATE OWNER PROCEDURE
OR OVERRIDE RESTORE
OS OVERRIDE SELECT POLICY
OU OVERRIDE UPDATE POLICY
PC CREATE PROCEDURE
PD DROP PROCEDURE
PE EXECUTE PROCEDURE
R RETRIEVE/SELECT
RF REFERENCE
RO REPLCONTROL
RS RESTORE
SA SECURITY CONSTRAINT ASSIGNMENT
SD SECURITY CONSTRAINT DEFINITION
SH SHOW
SR SET RESOURCE RATE
SS SET SESSION RATE
ST STATISTICS
TH CTCONTROL
U UPDATE
UM UDT METHOD
UT UDT TYPE
UU UDT USAGE
W1 WITH DATASET SCHEMA
ZO ZONE OVERRIDE

 

ConstraintType Column

Value Description
C Explicit table-level constraint check
P Nonpartitioned Primary Index
Q Partitioning constraint
S Hash-ordered Secondary Index without ALL
K Primary key
U Unique constraint
R References constraint
V Value-ordered Secondary Index without ALL
H Hash-ordered Secondary Index with ALL
O Value-ordered secondary with ALL

 

JournalFlag Column

Value Description
N No journal (default)
S Single journal
D Dual journal
L Local AFTER journal (not used for BEFORE)

 

StatsSource Column

Value Description
I Internally generated
S User collected with COLLECT STATS (system built)
U User collected with COLLECT STATS VALUES clause
C Copied from other sources
T Transferred with CREATE TABLE…AS statement

 

TableKind Column

Value Description
A Aggregate function
B Combined aggregate and ordered analytical function
C Table operator parser contract function
D JAR
E External stored procedure
F Standard function
G Trigger
H Instance or constructor method
I Join index
J Journal
K Foreign server object.
Note:K is supported on the Teradata-to-Hadoop and Teradata-to-Teradata connectors.
L User-defined table operator
M Macro
N Hash index
O Table with no primary index and no partitioning
P Stored procedure
Q Queue table
R Table function
S Ordered analytical function
T Table with a primary index or primary AMP index,partitioning, or both. Or apartitioned table with NoPI
U User-defined type
V View
X Authorization
Y GLOP set
Z UIF
1 A DATASET schema object created by CREATE SCHEMA.

 

Thank you for giving your valuable time to read the above information.
Follow us on 
Website  www.ktexperts.com
Facebook Page KTExperts Facebook
Linkedin Page : KT EXPERTS Linkedin

Share via:
Note: Please test scripts in Non Prod before trying in Production.
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

Add Comment