Sybase Adaptive Server Anywhere - SYSARTICLECOLS System View

Chapter 16 System Views
1053
SYSARTICLECOLS system view
CREATE VIEW SYS.SYSARTICLECOLS
AS SELECT (select publication_name FROM
SYS.SYSPUBLICATION AS p
WHERE p.publication_id=ac.publication_id) AS
publication_name,
(select table_name FROM SYS.SYSTABLE AS t
WHERE t.table_id=ac.table_id) AS table_name,
select column_name FROM SYS.SYSCOLUMN AS c
WHERE c.table_id=ac.table_id
AND c.column_id=ac.column_id) AS column_name
FROM SYS.SYSARTICLECOL AS ac
Presents a readable version of the table SYSARTICLECOL.