Unanswered: How to get the definition of a column and relationship information
Is this possible to get the definition of a column and relationship information in one big query in db2? On the other word, get column's name, data type, scale etc. as well as is this column a foreign key, a primary key, an identity etc. in one query.
I know you can get definition of a column from syscat.column and relationship information from syscat.references, but I want to just use one query to get all these information, I wonder may be somebody already did it.