Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 27 May 2004 @ 14:08:26 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


Subj:   Re: Column domains in DBC...
 
From:   Dempsey, Mike

There is no domain table for these codes (or for the IndexType codes, or the 'table' type codes)

Teradata Administrator converts all these codes to meaningfull strings however so you can either

a) Use Teradata Administrator - in which case you don't need to know the codes.

b) use the lists below. (From TDAdmin) You could create your own table(s) if you need to join to these codes.


Table Type:

     T  Table
     V  View
     M  Macro
     G  Trigger
     P  Stored Procedure
     I  Join Index
     N  Hash Index
     F  User Defined Function
     A  UDF (Aggregate)
     O  UDF (OLAP)
     S  UDF ()

Index Type:

     P  Primary
     S  Secondary
     K  Primary Key Constraint
     U  Unique Constraint
     Q  Partitioned
     V  Value Ordered Secondary
     J  Join Index
     N  Hash Index
     O  Value Ordered Secondary (All)
     H  Hash Ordered Secondary (All)
     1  Not an index - ordering column
     2  Not an index - ordering column
     M  Not an Index

Access Rights:

     AF   ALTER FUNCTION
     AP   ALTER PROCEDURE
     AS   ABORT SESSION
     CD   CREATE DATABASE
     CF   CREATE FUNCTION
     CG   CREATE TRIGGER
     CU   CREATE USER
     CM   CREATE MACRO
     CP   CHECKPOINT
     CT   CREATE TABLE
     CV   CREATE VIEW
     D    DELETE
     DD   DROP DATABASE
     DF   DROP FUNCTION
     DG   DROP TRIGGER
     DM   DROP MACRO
     DU   DROP USER
     DP   DUMP
     DT   DROP TABLE
     DV   DROP VIEW
     E    EXECUTE
     EF   EXECUTE FUNCTION
     I    INSERT
     IX   INDEXES
     MR   MONITOR RESOURCE
     MS   MONITOR SESSION
     PC   CREATE PROCEDURE
     PD   DELETE PROCEDURE
     PE   EXECUTE PROCEDURE
     R    RETRIEVE/SELECT
     RF   REFERENCES
     RS   RESTORE
     SS   SET SESSION RATE
     SR   SET RESOURCE RATE
     U    UPDATE

Mike Dempsey
Teradata Client Tools



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023