cancel
Showing results for 
Search instead for 
Did you mean: 

where to see article definition resulting of CREATE PUBLICATION Statment

Baron
Participant
0 Kudos
470

I know that table names of article definition are listed in table SYSARTICLES, but where are the column definitions to see?

For example:

create publication MYPUB (table MYTABLE(COL1, COL3, COL4));

With which query can I find which columns of MYTABLE are synchronising? Since the table SYSARTICLES shows only tablename.

View Entire Topic
VolkerBarth
Contributor

Try SYSARTICLECOL / SYSARTICLECOLS...