Archives of the TeradataForum

Message Posted: Tue, 06 May 2003 @ 15:50:06 GMT

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

Hi,

In 4.1 we added a new flavor of this

SHOW QUALIFIED .....

and it will make sure the Database names are added to the results just in case you need to know which databases the tables are in. Some people have the same table name in multiple databases so having the results FULLY QUALIFIED is a must.

SHOW can be used against any SQL.

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