All the object in teradata is listed in "dbc.tables", different objects are differentiated through column "Tablekind"
List of table kind:
O = NOPI TABLE
D = JAR
List of table kind:
| A | = | AGGREGATE UDF |
| B | = | COMBINED AGGREGATE AND ORDERED ANALYTICAL FUNCTION |
| E | = | EXTERNAL STORED PROCEDURE |
| F | = | SCALAR UDF |
| G | = | TRIGGER |
| H | = | INSTANCE OR CONSTRUCTOR METHOD |
| I | = | JOIN INDEX |
| J | = | JOURNAL |
| M | = | MACRO |
| N | = | HASH INDEX |
| P | = | STORED PROCEDURE |
| Q | = | QUEUE TABLE |
| R | = | TABLE FUNCTION |
| S | = | ORDERED ANALYTICAL FUNCTION |
| T | = | TABLE |
| U | = | USER-DEFINED DATA TYPE |
| V | = | VIEW |
| X | = | AUTHORIZATION |
D = JAR
No comments:
Post a Comment