'TERADATA: SEARCH FOR COLUMNNANE IN DATABASE

I have a database name called 'xxx' which returns a bunch of tables.. I want to be able to return only the tables that have a specific column in them. I managed go get all the tables to show:

SELECT  DatabaseName,
        TableName,
        CreateTimeStamp,
        LastAlterTimeStamp
FROM    DBC.TablesV
WHERE   TableKind = 'T' and     DatabaseName = 'XXX'
ORDER BY    TableName;

HOW Can I return only the tables that have a specific column.

sqlteradata


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions