Connecting Tech Pros Worldwide Help | Site Map
bytes > topic > db2 > answers

retrieve all table names from DB2

Newbie
  
Join Date: Mar 2009
Posts: 1
#1: Mar 24 '09
hi..

i want to dynamically retrieve all the table names from DB2. can anyone suggest me a procedure to do that. or is there any sample code available..??
Member
  
Join Date: Aug 2007
Posts: 51
#2: Mar 25 '09

re: retrieve all table names from DB2

Something like this is what you are after:
Expand|Select|Wrap|Line Numbers
  1. select rtrim(T.tabschema)||'.'||rtrim(T.tabname) as table_name
  2.   from syscat.tables T 
  3.   with ur
Reply

« previous question | next question »

Similar DB2 Database bytes

/bytes/development

/bytes/it

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,295 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml
it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved