Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » Views » Consolidated views

SYSARTICLECOLS consolidated view Next Page

SYSARTICLES consolidated view


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