Once you create a view, where would information about the view be stored?
9 August 2009
200 views
No Comment
(No Ratings Yet)
Loading ...When a view is created, system information about the view is stored in SYSIBM.SYSVIEWS.
Popularity: unranked [?]
Related interview questions
- What information can you find in SYSIBM.SYSLINKS table?
- What information is held in SYSIBM.SYSCOPY?
- 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?
- What is meant by synonym?
- What is a view?
Leave your response!
You must be logged in to post a comment.