Hi Sandra "select * from tables" will give you a list of all tables in the TSM database against which you can run queries. The result will containt remarks that explain what each table containts.
Select * from columns will give you all table columns. For example, "select * from columns where tabname='NODES' will give you all columns within the NODES table. Best Regards Daniel Sparrman ----------------------------------- Daniel Sparrman CIO Exist i Stockholm AB Propellerv�gen 6B 183 62 T�BY V�xel: 08 - 754 98 00 Mobil: 070 - 399 27 51 Sandra <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 2004-11-08 17:11 Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To [EMAIL PROTECTED] cc Subject TSM Database architechture ?? Dear All, Where and how do I learn about TSM database architechture?? When I see that you people give select queries to answer questions, I get a hisckup.. how do they know all that??? So please let me know too .. how do i go about learning that? Kind Regards, Sandra
