Chapter 3 Guide de référence du SGBD

SqlAttrQuery

Requête SQL permettant d'extraire des information supplémentaires sur les objets récupérés via reverse engineering par SQLListQuery .

Exemple

Dans Oracle 8 :

{OWNER, TABLE, COMMENT}
         
[%ISODBCUSER% ?
SELECT '%SCHEMA%', TABLE_NAME, COMMENTS 
FROM SYS.USER_TAB_COMMENTS
WHERE COMMENTS IS NOT NULL [AND TABLE_NAME='%TABLE%']
ORDER BY TABLE_NAME
:
SELECT OWNER, TABLE_NAME, COMMENTS 
FROM SYS.ALL_TAB_COMMENTS
WHERE COMMENTS IS NOT NULL [AND OWNER='%SCHEMA%'] [AND TABLE_NAME='%TABLE%']
ORDER BY OWNER, TABLE_NAME
]

Voir aussi SqlListQuery .

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