PROVE IT !!If you know it then PROVE IT !! Skill Proficiency Test

How to generate list of tables having UNNECESSARY CASESPECIFIC defined in column ?

Q 35 ) How to generate list of tables having UNNECESSARY CASESPECIFIC defined in column ?
Answer >

sel DatabaseName, TableName, ColumnName, UpperCaseFlag,ColumnType
from DBC.Columns
where databasename like ‘EDW1%’
and ColumnType like ‘C%’
and UpperCaseFlag = ‘C’
and (databasename,tablename) NOT IN (
sel databasename, tablename from dbc.tables where
databasename in (<<<*********** LIST OF USER NAME USED ***********>>>>>)
and tableKind=’T’
group by 1,2 )
order by 1,2,3;

Add a Comment

Your email address will not be published. Required fields are marked *