SQL
SELECT
CONCAT(c.TABLE_NAME, '.', c.COLUMN_NAME) AS 'Column'
FROM
information_schema.columns AS c
WHERE
c.TABLE_SCHEMA LIKE '%_dwh_ports'
Output
cardinals.digit
connected_device_dimension.firmware
connected_device_dimension.id
connected_device_dimension.latest
connected_device_dimension.manufacturer
connected_device_dimension.model
connected_device_dimension.name
connected_device_dimension.tk
connected_device_dimension.type
date_dimension.dateYear
date_dimension.dayInMonth
date_dimension.dayInQuarter
date_dimension.dayInWeekNum
date_dimension.dayInYear
date_dimension.fullDate
date_dimension.future
date_dimension.latest
date_dimension.monthLabel
date_dimension.monthNum
date_dimension.quarter
date_dimension.quarterLabel
date_dimension.repDay
date_dimension.repMonth
date_dimension.repMonthOrLatest
date_dimension.repQuarter
date_dimension.repWeek
date_dimension.sspFlag
date_dimension.tk
date_dimension.yearLabel
port_dimension.dateTk
port_dimension.gbicType
port_dimension.id
port_dimension.isGenerated
port_dimension.latest
port_dimension.name
port_dimension.speed
port_dimension.tk
port_dimension.type
port_dimension.url
port_dimension.wwn
ports_fact_current.connectedDeviceTk
ports_fact_current.connectivityType
ports_fact_current.dateTk
ports_fact_current.fabric
ports_fact_current.portTk
ports_fact_current.speed
ports_fact_current.status
ports_fact_current.switchTk
ports_fact_current.tk
ports_fact_current.type
ports_fact.connectedDeviceTk
ports_fact.connectivityType
ports_fact.dateTk
ports_fact.fabric
ports_fact.portTk
ports_fact.speed
ports_fact.status
ports_fact.switchTk
ports_fact.tk
ports_fact.type
switch_dimension.dataCenter
switch_dimension.dateTk
switch_dimension.firmware
switch_dimension.id
switch_dimension.identifier
switch_dimension.ip
switch_dimension.isGenerated
switch_dimension.latest
switch_dimension.manufacturer
switch_dimension.model
switch_dimension.name
switch_dimension.npv
switch_dimension.region
switch_dimension.serialNumber
switch_dimension.switchLevel
switch_dimension.tk
switch_dimension.type
switch_dimension.url
switch_dimension.wwn
Comments
Post a Comment