var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to retrieve information about the database objects
In SQL Server we ve some system tables which have some information about the database,
1. sysobjects : which stores the information regarding the database objects like table, procedure , etc...
it has information like the name of the object, type (procedure or table or trigger ...), specific id for the object.
2. systypes : it has information about the data types like, the name of the datatype, the space it occupies, physical storage type, etc..
I want to retrieve similar information from DB2, Kindly guide me to find the equivalent information in DB2,.
Look for tables with schema name SYSIBM, SYSCAT, ...
With kind regards . . . . . SQL Server 2000/2005/2012
Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages
THanks for the links and the suggestions. I ll try to use them.