Archives of the TeradataForum

Message Posted: Tue, 22 Jun 2004 @ 13:39:09 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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;

	<Prev	Next>		<<First	<Prev	Next>	Last>>