select * from MetaDataTable
select * from MetaDataField
Select distinct TableName, TableName2 from MetaDataField
update MetaDataField set AliasName2 = 'PT' where TableName='Patient'
update MetaDataField set AliasName2 = 'CL' where TableName='Clinical'
update MetaDataField set AliasName2 = 'EX' where TableName='Exam'
update MetaDataField set AliasName2 = 'FO' where TableName='FillerOrder'
update MetaDataField set AliasName2 = 'FC' where TableName='FinancialCharge'
update MetaDataField set AliasName2 = 'FCM' where TableName='FinancialChargeMaster'
update MetaDataField set AliasName2 = 'FCT' where TableName='FinancialChargeType'
update MetaDataField set AliasName2 = 'FTE' where TableName='FTE'
update MetaDataField set AliasName2 = 'ICD9' where TableName='ICD9Code'
update MetaDataField set AliasName2 = 'MO' where TableName='Modality'
update MetaDataField set AliasName2 = 'PR' where TableName='Provider'
update MetaDataField set AliasName2 = 'VI' where TableName='Visit'
update MetaDataField set AliasName2 = 'CD' where TableName='vwCalendarDate'
update MetaDataField set AliasName2 = 'CT' where TableName='vwCalendarTime'
update MetaDataField set AliasName2 = 'EWF' where TableName='ExamWorkflow'
update MetaDataField set AliasName2 = 'CPT' where TableName='CPTRVU'
update MetaDataField set AliasName2 = 'EF' where TableName='ExamFlat'
update MetaDataField set AliasName2 = 'PDR' where TableName='vwPatientDrillThru'
update MetaDataField set AliasName2 = 'FTEDR' where TableName='FTEDrillThru'
update MetaDataField set AliasName2 = 'EXF' where TableName='ExamFlatFact'


select * from MetaDataTable