Teradata

1. How to get the list of all the tables , views and stored procedures etc from a  Teradata database.


select TableKind , TableName from DBC.TABLES where DatabaseName='db_name'

TableKind  can be T, O, Q, P, V ....