The following SELECT statement selects information about tables copied into the Personnel database:
SELECT Original_DatabaseName,Original_TableName,TableName FROM DBC.AssociationV WHERE DatabaseName = ’Personnel’;
Result:
Original_DatabaseName Original_TableName TableName --------------------- ------------------ ----------- OldPersonnel Empl_Addr Emp_Address Personnel2 Empl_Dept Empl_Dept