Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Getting List of all databases on server

Status
Not open for further replies.
neemi

neemi

Programmer
Joined
May 14, 2002
Messages
519
Location
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

 
Sort by date Sort by votes
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
Status
Not open for further replies.

Similar threads

Preshit
  • Locked
  • Question Question
Number of working days between two date fields
Replies
1
Views
678
johnherman
johnherman
nambir
  • Locked
  • Question Question
NEED TO TEST ON THREE DIFFERENT DATES
Replies
1
Views
513
SamBones
SamBones
btrini
  • Locked
  • Question Question
Fastload logon shows as invalid but I can log on to Teradata SQL Assistant with the same credentials
Replies
1
Views
553
SamBones
SamBones
ianbrown76
  • Locked
  • Question Question
Find ASCII code of characters in columns
Replies
0
Views
434
ianbrown76
ianbrown76
dechrist
  • Locked
  • Question Question
Check characters not in list
Replies
0
Views
278
dechrist
dechrist

Part and Inventory Search

Sponsor

Back
Top