|
View previous topic :: View next topic
|
| Author |
Message |
mdtanweer
New User
Joined: 26 Mar 2009
Posts: 6
Location: Bangalore
|
|
|
|
Hi All,
Is it possible to know the name of the database using Query. If so please let me know the syntax of that query.
Many thanks in advance.
Regards. |
|
| Back to top |
|
 |
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales
|
|
|
|
What have you tried and/or researched for yourself.
There was a very similar topic discussed on this forum not so long ago.
Did you use the SEARCH button at the top of any page ? |
|
| Back to top |
|
|
mdtanweer
New User
Joined: 26 Mar 2009
Posts: 6
Location: Bangalore
|
|
|
|
Yeah, i have tried searching under the DB2 forum but unfortunately did not got the relevent answer.
My question is that there can be few tables under a single database. Is there any way I can get the name of that database through Query. |
|
| Back to top |
|
|
kacks7
New User
Joined: 22 Sep 2010
Posts: 33
Location: chennai(india)
|
|
|
|
i think this may be usefull fro u
| Code: |
SELECT DBNAME FROM SYSIBM.SYSTABLES
WHERE NAME = 'UR_TABLE_NAME'; |
|
|
| Back to top |
|
|
|
|
