/scripts/ahub.form.attachments.js
1

ISYSARTICLECOL

Mar 02, 2017 at 08:01 AM

84

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Volker Barth Mar 02, 2017 at 08:45 AM
1

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.

Share
10 |10000 characters needed characters left characters exceeded
Skip to Content