Update: Please confirm this query makes sense...
-- Look for existing MobiLink and SQL Remote objects on the remote database. SELECT 1, * FROM SYSARTICLE; -- MobiLink SQL Remote SELECT 2, * FROM SYSARTICLECOL; -- MobiLink SQL Remote SELECT 3, * FROM SYSPUBLICATION; -- MobiLink SQL Remote SELECT 4, * FROM SYSREMOTEOPTION; -- SQL Remote SELECT 5, * FROM SYSREMOTEOPTIONTYPE; -- SQL Remote SELECT 6, * FROM SYSREMOTETYPE; -- SQL Remote SELECT 7, * FROM SYSREMOTEUSER; -- SQL Remote * SELECT 8, * FROM SYSSUBSCRIPTION; -- SQL Remote SELECT 9, * FROM SYSSYNC; -- MobiLink ** SELECT 10, * FROM SYSSYNCPROFILE; -- MobiLink SELECT 11, * FROM SYSSYNCSCRIPT; -- MobiLink -- * rows exist if and only if SQL Remote is in use. -- ** rows exist if and only if MobiLink is in use.
Sometimes it's just easier to ask forgiveness for asking a question than to reverse-engineer.
The SYSPUBLICATION.type column contains an 'R' but that column has been marked "deprecated" since it first appeared in the V8 docs... all the way through to V17 :)