Is there a way in teradata SQL assistant to run a query that provides all the tables and all of their corresponding columns?

Question

Basically looking for how to do this in Teradata SQL Assistant. Thanks!

score 0 · Accepted Answer · answered Apr 27 '20 at 23:26

0

try the following

SELECT DatabaseName, TableName, ColumnName
FROM dbc.ColumnsV

answered Apr 27 '20 at 23:26

zealous

1 Answers1