The statement shown in the following selects information about the Personnel database:
SELECT AccountName,ProtectionType,PermSpace,SpoolSpace FROM DBC.DatabasesV WHERE DatabaseName = ’Personnel’;
Result:
AccountName ProtectionType PermSpace SpoolSpace --------------- -------------- --------- ------------- Teradata_Sample F 100,000 1,339,884,032