Actually, this will give you all the columns of all the tables, a big list. You may want to look at what tables there are first, then add a "where tabname = 'thetable'" to the end of what Bill suggests:
SELECT * from SYSCAT.TABLES -----Original Message----- From: Bill Boyer [mailto:[EMAIL PROTECTED]] Sent: Friday, February 15, 2002 4:55 PM To: [EMAIL PROTECTED] Subject: Re: TSM Database Tables SELECT * FROM COLUMNS ORDER BY TABNAME,COLNAME Or use the ODBC interface and extract the information directly into an Excel table. -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Patricia LeBlanc Sent: Friday, February 15, 2002 3:40 PM To: [EMAIL PROTECTED] Subject: TSM Database Tables Anyone know where I can find (online) an updated copy of the TSM Database Tables? Thanks, pattie Liberty Mutual Backup and Recovery
