Chapter 3 DBMS Reference Guide

SqlListQuery

SQL Query for listing objects in reverse engineering dialog.

The query is executed to fill header variables and create objects in memory.

Example

{OWNER, TABLE, COLUMN, DTTPCODE, LENGTH, SIZE, PREC, NOTNULL (N='NOT NULL', *=NULL), DEFAULT, COMMENT}

[%ISODBCUSER% ?
SELECT '%SCHEMA%', C.TABLE_NAME, C.COLUMN_NAME, C.DATA_TYPE, C.DATA_PRECISION, C.DATA_LENGTH, C.DATA_SCALE, C.NULLABLE, C.DATA_DEFAULT, M.COMMENTS
FROM SYS.USER_COL_COMMENTS M, SYS.USER_TAB_COLUMNS C
WHERE M.TABLE_NAME = C.TABLE_NAME AND M.COLUMN_NAME = C.COLUMN_NAME
      [AND C.TABLE_NAME='%TABLE%']
ORDER BY C.TABLE_NAME, C.COLUMN_ID
:
SELECT C.OWNER, C.TABLE_NAME, C.COLUMN_NAME, C.DATA_TYPE, C.DATA_PRECISION, C.DATA_LENGTH, C.DATA_SCALE, C.NULLABLE, C.DATA_DEFAULT, M.COMMENTS
FROM SYS.ALL_COL_COMMENTS M, SYS.ALL_TAB_COLUMNS C
WHERE M.OWNER = C.OWNER AND M.TABLE_NAME = C.TABLE_NAME AND M.COLUMN_NAME = C.COLUMN_NAME
      [AND C.OWNER='%SCHEMA%'] [AND C.TABLE_NAME='%TABLE%']
ORDER BY C.OWNER, C.TABLE_NAME, C.COLUMN_ID
]

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