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

Consolidated views Next Page

SYSARTICLECOLS consolidated view

Each row in the SYSARTICLECOLS view identifies a column in an article.

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.

  as select p.publication_name,t.table_name,c.column_name from
    SYS.SYSARTICLECOL as ac join
    SYS.SYSPUBLICATION as p on p.publication_id = ac.publication_id join
    SYS.SYSTABLE as t on t.table_id = ac.table_id join
    SYS.SYSCOLUMN as c on c.table_id = ac.table_id and
    c.column_id = ac.column_id
See also