Database Validation Query

From Chorke Wiki
Revision as of 21:03, 18 September 2019 by Shahed (talk | contribs) (Created page with "<source lang="sql"> SELECT 1 --microsoft sql server (tested on sql-server 9.0, 10.5 [2008]) SELECT 1 FROM INFORMATION_SCHEMA.SYSTEM_USERS -- hsqldb SELECT 1 FROM sysibm.sysdum...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search 
SELECT 1 --microsoft sql server (tested on sql-server 9.0, 10.5 [2008])
SELECT 1 FROM INFORMATION_SCHEMA.SYSTEM_USERS -- hsqldb
SELECT 1 FROM sysibm.sysdummy1 --db2
SELECT 1 FROM rdb$database --firebird
SELECT 1 FROM dual -- oracle
SELECT 1 -- postgresql
SELECT 1 -- ingres
SELECT 1 -- mysql
VALUES 1 -- derby 
SELECT 1 -- h2

References

Retrieved from "https://cdn.chorke.org/weke/index.php?title=Database_Validation_Query&oldid=1864"