Teradata / Sql Server - List all the column names in a database

List all the table and column names in a database

Sql Server Select * from INFORMATION_SCHEMA.COLUMNS where TABLE_CATALOG = 'DatabaseName' Order by TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME;

Teradata Select * from dbc.columns where databasename='DatabaseName' order by DatabaseName, TableName, ColumnName ;

Use below if you need the list of column names from view Select * from dbc.columnsv where databasename='DatabaseName' order by DatabaseName, TableName, ColumnName ;