Chapter 3 DBMS Reference Guide

SqlChckQuery

SQL Query to reverse engineer column check parameters.

The result must conform to proper SQL syntax.

Example

In Sybase Adaptive Server Anywhere 6:

{OWNER, TABLE, COLUMN, CONSTRAINT}
SELECT SU.USER_NAME, ST.TABLE_NAME, SC.COLUMN_NAME, SC."CHECK"
FROM SYSUSERPERMS SU, SYSTABLE ST, SYSCOLUMN SC
WHERE [SU.USER_NAME='%OWNER%' AND] [ST.TABLE_NAME='%TABLE%' AND]
ST.CREATOR=SU.USER_ID AND SC.TABLE_ID=ST.TABLE_ID AND
SC."CHECK" IS NOT NULL
ORDER BY SU.USER_NAME, ST.TABLE_ID

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