Introduction of Teradata Database

The concept of teradata system is little bit different. There is only one database(your teradata system) with lots of (schemas/users). Here (schemas/users) is called database.
In this system dbc is the owner of all metadata. In dbc you can find all the object of teradata.

To get all tables name which consist the particular column.

select tablename, columnname from dbc.columns where columnname ='Emp_Id' and databasename = 'EMPDB';

To see all the objects in a particular database.

Help database databasename;