|
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 )