CREATE VIEW SYS.SYSARTICLES AS SELECT(select publication_name FROM SYS.SYSPUBLICATION AS p WHERE p.publication_id=a.publication_id) AS publication_name, (select table_name FROM SYS.SYSTABLE AS t WHERE t.table_id=a.table_id) AS table_name, where_expr,subscribe_by_expr FROM SYS.SYSARTICLE AS a
Presents a readable version of the table SYSARTICLES.