SELECT  TABLE_NAME, COLUMN_NAME, DATA_TYPE 
FROM INFORMATION_SCHEMA.COLUMNS
WHERE 
     TABLE_NAME IN  ('dcsAAH_and_Enterprise_Reps_FullConstruct_W01_UK',
'dcsCEDAR_CG3_Legacy_Partner_Type_FullConstruct_UK',
'dcsCedar_Internet_Address_Partner_Company_Clerk_FullConstruct_W01_UK',
'dcsCustomer_Exclusion_Inclusion_FullConstruct_W01_UK',
'dcsDC_Supplying_Site_FullConstruct_W01_UK',
'dcsING_QSP_CDR_Affiliates_FullConstruct_UK',
'dcsIngres_Accounting_Clerk_FullConstruct_W01_UK',
'dcsINGRES_CD_Licenses_41_42_FullConstruct_W01_UK',
'dcsINGRES_Cust_Type_7_Splitting_FullConstruct_W01_UK',
'dcsIngres_Internet_Address_Partner_Company_Clerk_FullConstruct_W01_UK',
'dcsIngres_Sap_CG3_FullConstruct_W01_UK',
'dcsIngres_Unknown_Partner_FullConstruct_W01_UK',
'dcsIngres_WDA_Licenses_FullConstruct_W01_UK',
'dcsKNVH_Hierarchy_Type',
'dcsKONP_AAH_Ingres_op_products',
'dcsQSP_CG3_Legacy_Partner_Type_FullConstruct_UK',
'dcsVendor_Exclusion_Inclusion_FullConstruct_W01_UK',
'dcsVendor_Partner_Function_FullConstruct_W01_UK')
 AND 
     COLUMN_NAME IN ( 'CONFIRMED', 'CONFIRM', 'APPROVE', 'APPROVED')