Michael,
Assuming we're talking DB2, this would be:
SELECT CREATOR, NAME
FROM SYSIBM.SYSTABLES;
You might want to add a WHERE clasue,
and probably an ORDER BY.
Please be aware that directory tables are
not present in SYSIBM.SYSTABLES,
though their tablespaces may occur in
SYSIBM.SYSCOPY.
Success,
Abe Kornelis.
=========
----- Original Message -----
From: "Micheal Butz" <[email protected]>
Newsgroups: bit.listserv.ibm-main
To: <[email protected]>
Sent: Monday, April 04, 2011 4:29 PM
Subject: DB2 Tables In a database
Hi,
Would anyone know the SQL statement to list all the tables in a database
Thanks
Sent from my iPhone
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html
-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1209 / Virus Database: 1500/3549 - Release Date: 04/04/11
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html
