Archives of the TeradataForum
Message Posted: Tue, 22 Jun 2004 @ 13:39:09 GMT
Just suggesting a workaround. There could be a better way to deal with this.
The following sql will always return zero rows as column DatabaseName is NOT NULL column of the underlying DBC.DBase table. If the user has access to this view, you may use it.
Select count(*) from DBC.Databases where DatabaseName IS NULL;
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|