How to check Teradata Database version

Queries below return database version information.

Query

SELECT  InfoData AS Version
FROM    DBC.DBCInfoV
WHERE   InfoKey = 'VERSION';

Columns

  • Version - version of Teradata Database

Rows

Query returns one row with Teradata Database version.

Sample results