|
View previous topic :: View next topic
|
| Author |
Message |
kavya123
Warnings : 1
New User
Joined: 11 Jul 2007
Posts: 34
Location: hyderabad
|
|
|
|
hi!
i have created some 20 tables i Need a query by which I can view all the tables present in the database.
can anyone help me out. |
|
| Back to top |
|
 |
guptae
Moderator
Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India
|
|
|
|
Hi there,
U can use following query
| Code: |
SELECT NAME
FROM SYSIBM.SYSTABLES
WHERE DBNAME LIKE ('CC1M%'); |
Here it will show name of all the tables for database CC1M.Please change database name according to ur requirement |
|
| Back to top |
|
|
mbr_raja
New User
Joined: 15 Nov 2004
Posts: 26
Location: Chennai, India
|
|
|
|
select * from sysibm.systables where type = 't' and database = 'first' and
tablespace = 'second';
you have to give exactly the database and tablespace while running the query. |
|
| Back to top |
|
|
|
|
