Chapter 3 DBMS Reference Guide

SqlAttrQuery

SQL Query to retrieve additional information on object reversed by SQLListQuery .

Example

In Oracle 8:

{OWNER, TABLE, COMMENT}
         
[%ISODBCUSER% ?
SELECT '%SCHEMA%', TABLE_NAME, COMMENTS 
FROM SYS.USER_TAB_COMMENTS
WHERE COMMENTS IS NOT NULL [AND TABLE_NAME='%TABLE%']
ORDER BY TABLE_NAME
:
SELECT OWNER, TABLE_NAME, COMMENTS 
FROM SYS.ALL_TAB_COMMENTS
WHERE COMMENTS IS NOT NULL [AND OWNER='%SCHEMA%'] [AND TABLE_NAME='%TABLE%']
ORDER BY OWNER, TABLE_NAME
]

See also SqlListQuery .

Copyright (C) 2006. Sybase Inc. All rights reserved.