Chapter 3 DBMS Reference Guide

SqlOptsQuery

SQL Query to retrieve object physical options from object reversed by SqlListQuery .

The result of the query will fill the variable %OPTIONS% and must respect SQL syntax.

Example

In Sybase Adaptive Server Anywhere 6:

{OWNER, TABLE, OPTIONS}
select su.USER_NAME, st.TABLE_NAME, 'in '+ dbspace_name 
from SYS.SYSUSERPERMS su, SYS.SYSTABLE st, SYS.SYSFILE sf
where
st.file_id = sf.file_id and dbspace_name <> 'SYSTEM' and
[%TABLE% ? TABLE_NAME = '%TABLE%' and] [%SCHEMA% ? su.USER_NAME = '%SCHEMA%' and]
st.CREATOR = su.USER_ID

See also SqlListQuery .

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