Each row in the SYSARTICLES view describes an article in a publication.
The tables and columns that make up this view are provided in the SQL statement below. To learn more about a particular table or column, use the links provided beneath the view definition.
CREATE VIEW SYS.SYSARTICLES AS SELECT u1.user_name as publication_owner, p.publication_name, u2.user_name as table_owner, t.table_name, a.where_expr, a.subscribe_by_expr, a.alias FROM SYS.ISYSARTICLE a JOIN SYS.ISYSPUBLICATION p ON ( a.publication_id = p.publication_id ) JOIN SYS.ISYSTAB t ON ( a.table_id = t.table_id ) JOIN SYS.ISYSUSER u1 ON ( p.creator = u1.user_id ) JOIN SYS.ISYSUSER u2 ON ( t.creator = u2.user_id )