投稿日:

各データベース バージョン取得SQL


/* MySQL */
SELECT VERSION();

/* Firebird */
SELECT rdb$get_context('SYSTEM', 'ENGINE_VERSION') from rdb$database;

/* PostgreSQL */
SELECT version();

/* SQL Server */
SELECT CAST(SERVERPROPERTY('productversion') AS VARCHAR(30));

/* SQL AnyWhere */
SELECT TOP 1 version
FROM SYSHISTORY
WHERE operation = 'START'
ORDER BY first_time_utc DESC;

/* sqlite */
select sqlite_version();

/* Oracle */
select * from v$version WHERE ROWNUM = 1;