How to find all the tables created by specific user in Teradata?

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

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