查询库中同义词

SELECT t.tabname AS synname,s.servername targetinstance,s.dbname targetdbname,s.tabname targettabname FROM systables t,syssyntable s
WHERE t.tabid=s.tabid
and t.tabtype IN('S','Q');

输出示例：

synname         syntestdb1tab1
targetinstance
targetdbname    testdb1
targettabname   tab1