Reference Manual
CHAPTER 16. System Views
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.