Sometimes you may need to check all the available databases in the Teradata server. Teradata provides a couple of different ways to get the information.
The easiest way to list all the databases in Teradata using the following query:
SELECT DatabaseName, OwnerName FROM DBC.DATABASESV WHERE DBKind = 'D';
You will get output like this.
In case, you want the list of database users created in the Teradata system, you use the below query.
SELECT DatabaseName, OwnerName FROM DBC.DATABASESV WHERE DBKind = 'U';
You will get output something like this.