Chapter 3 DBMS Reference Guide

SqlChckQuery

SQL Query to reverse engineer table checks.

Example

In Sybase Adaptive Server Anywhere 6:

{OWNER, TABLE, CONSTRAINT}
SELECT U.USER_NAME, T.TABLE_NAME, T.VIEW_DEF 
FROM SYSUSERPERMS U, SYSTABLE T
WHERE [U.USER_NAME = '%OWNER%' AND] [T.TABLE_NAME = '%TABLE%' AND]
T.CREATOR = U.USER_ID AND T.TABLE_TYPE = 'BASE' AND T.VIEW_DEF IS NOT NULL

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