向视图添加额外的列，该列不存在于表中

这听起来像你只是想一个额外的硬编码值添加到您的

SELECt

CREATE OR REPLACE VIEW DETAILSAS SELECT * FROM(SELECt     T1.ID,    T1.AMOUNT,    T1.STATUS,    T1.ADDEDBY,    T1.ADDEDON,    'T1' tableIDFROM Table1 T1UNIOn ALLSELECt     T2.ID,    T2.AMOUNT,    T2.STATUS,    T2.ADDEDBY,    T2.ADDEDON,    'T2' tableIDFROM Table2 T2UNIOn ALLSELECt    T3.ID,    T3.BILLAMOUNT,    T3.STATUS,    T3.ADDEDBY,    T3.ADDEDON,    'T3' tableID  FROM Table3 T3);