To get all the column names used in database in Teradata

To get all columns,
select * from dbc.columns


Selecting columns for a particular table
select columnname from dbc.columns
where tablename ='tbl'
and databasename = 'database'