How to find all the tables created by specific user in Teradata?
Contents
Meta data tables in DBC database:
Teradata meta data tables are stored in DBC database.The table level information present in the DBC.Tables and the column level information present in the DBC.Columns. Similarly there are many useful meta data information stored in the DBC database.
Find all the tables created by specific User
|
1 2 3 4 5 |
select * from dbc.tablesv where CreatorName='Revisit_User1' and databasename = 'Banking_DB' and Tablekind = 'T'; |
The above query will fetch the all the tables created by User Revisit_User1 in the database Banking_DB. The TableKind field specifies the kind of object as T (table), V (view), P (stored procedure) or M (macro).
List of table kind options in DBC.Tablev
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
O = NOPI TABLE
D = JAR
Recommended Articles
- How to check the table size using query in Teradata?
- Teradata create table syntax with examples
- Create table as Select query in Teradata
