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 Mike Lewis 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
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

 
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
Number of working days between two date fields
Replies
1
Views
173
johnherman
johnherman
nambir
  • Locked
  • Question
NEED TO TEST ON THREE DIFFERENT DATES
Replies
1
Views
110
SamBones
SamBones
btrini
  • Locked
  • Question
Fastload logon shows as invalid but I can log on to Teradata SQL Assistant with the same credentials
Replies
1
Views
133
SamBones
SamBones
ianbrown76
  • Locked
  • Question
Find ASCII code of characters in columns
Replies
0
Views
132
ianbrown76
ianbrown76
dechrist
  • Locked
  • Question
Check characters not in list
Replies
0
Views
52
dechrist
dechrist

Part and Inventory Search

Sponsor

Back
Top