[펌글] 데이터베이스(DBMS) 버전(version) 확인하기

By itpsolver | 5월 26, 2014

- 출처: http://aircook.tistory.com/entry/Database-%EB%B2%84%EC%A0%84-%ED%99%95%EC%9D%B8 -

Oracle
SELECT * FROM v$version;
SELECT * FROM product_component_version;

MS-SQL
SELECT @@VERSION
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY('productlevel'), SERVERPROPERTY('edition')

MySql
SELECT VERSION();

Altibase
SELECT * FROM V$VERSION;