• Home
• com.sqlapp
• sqlapp-core-derby
• 0.8.4
• source code
• views.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

com.sqlapp.data.db.dialect.derby.metadata.views.sql Maven / Gradle / Ivy

SELECT V.VIEWDEFINITION
, T.TABLENAME AS table_name
, S.SCHEMANAME AS schema_name
FROM SYS.SYSVIEWS V
INNER JOIN SYS.SYSTABLES T
  ON (V.TABLEID=T.TABLEID)
INNER JOIN SYS.SYSSCHEMAS S
  ON (T.SCHEMAID=S.SCHEMAID)
WHERE 1=1 
  /*if isNotEmpty(schemaName)*/
  AND S.SCHEMANAME IN /*schemaName*/('%')
  /*end*/
  /*if isNotEmpty(tableName)*/
  AND T.TABLENAME IN /*tableName*/('%')
  /*end*/
ORDER BY S.SCHEMANAME, T.TABLENAME