Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

@alejandroSuch

alejandroSuch/validation_queries.md

Last active April 15, 2016 10:03
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save alejandroSuch/1ed28ea2a846c57521d7075f706a51c9 to your computer and use it in GitHub Desktop.
Save alejandroSuch/1ed28ea2a846c57521d7075f706a51c9 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
validation_queries.md
  • hsqldb: select 1 from INFORMATION_SCHEMA.SYSTEM_USERS
  • Oracle: select 1 from dual
  • DB2: select 1 from sysibm.sysdummy1
  • mysql: select 1
  • microsoft SQL Server: select 1 (tested on SQL-Server 9.0, 10.5 [2008])
  • postgresql: select 1
  • ingres: select 1
  • derby: values 1
  • H2: select 1
  • Firebird: select 1 from rdb$database
  • Informix: select 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment