DB2
select TARGETCOLUMNNAME, ISADD
from SYNC_COLUMN
where SYNCTABLEID in (
select id
from SYNC_TABLE
where CLIENTCODE = 'xxx'
and TARGETTABLENAME in (
select TABNAME
from SYSCAT.TABLES
where TABSCHEMA = 'xxx')
)
and TARGETCOLUMNNAME = 'xxx';
SQL server
select TARGETCOLUMNNAME, ISADD,UPDATETIME
from SYNC_COLUMN
where SYNCTABLEID in (
select id
from SYNC_TABLE
where CLIENTCODE = 'xxx'
and TARGETTABLENAME in (
select name
from sys.TABLES)
)
and TARGETCOLUMNNAME = 'xxx';