Chapter 3 DBMS Reference Guide
SQL Query to reverse engineer table checks.
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. |