In which column of which DB2 catalog would you find the length of rows for all tables?
9 August 2009
242 views
No Comment
(No Ratings Yet)
Loading ...In the RECLENGTH column of SYSIBM.SYSTABLES.
Popularity: unranked [?]
Related interview questions
- I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
- I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
- Where could you look if you had a question about whether a column has been defined as an index?
- Can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?
- MAX. NO OF ROWS PER PAGE
Leave your response!
You must be logged in to post a comment.