How do I tell if a remote.db has been used with SQL Remote versus MobiLink?

[Breck_Carter]

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.

---

Original question...

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 🙂

[VolkerBarth]

I'd look into SYSREMOTEUSER vs. SYSSYNC...