Sep 1, 2010 #1 neemi Programmer May 14, 2002 519 GB Is there a way I can get list of all the databases on the server when i am logged into teradata sql assistant? apologies for any dumn questions. Cheers, Nims
Is there a way I can get list of all the databases on the server when i am logged into teradata sql assistant? apologies for any dumn questions. Cheers, Nims
Sep 1, 2010 #2 Gruuuu Programmer Oct 7, 2008 543 US Certainly, but the problem is finding out which ones are useful Code: SELECT * FROM DBC.Databases ...will also pull up user databases. Remember, just because you can see a database's information, doesn't mean you have access to query it. Upvote 0 Downvote
Certainly, but the problem is finding out which ones are useful Code: SELECT * FROM DBC.Databases ...will also pull up user databases. Remember, just because you can see a database's information, doesn't mean you have access to query it.