avatar image
Former Member

ISYSARTICLECOL

Hi all,

I want to ask where can I see all the columns participating in all the publications (i.e. the resulted columns of calling the procedure "Create/Alter Publication add Table.....").

Actually the view SYSARTICLECOL returns the columns belonging only to one of the tables, and sometimes returns nothing.

Thanks in advance

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Mar 02, 2017 at 08:45 AM

    AFAIK, SYSARTICLECOL (like the compatibility view SYSARTICLECOLS) only lists those tables which have been published with an explicit column list. For tables published with all columns (i.e. without an explicit column list), you will have to join over SYSARTICLE and SYSTABCOL via table_id.

    Add comment
    10|10000 characters needed characters exceeded

Skip to Content