Chapter 3 Guide de référence du SGBD

SqlChckQuery

Requête SQL permettant de procéder au reverse engineering de vérifications de table.

Exemple

Dans 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.