-
DB2 Tutorial
DB2 Databases
- db2-create-database
- db2-activate-database
- db2-deactivate-database
- db2-connect-to-database
- db2-verify-database
- db2-check-db-authority
- db2-drop-database
DB2 Bufferpool
DB2 RazorSQL Tool
- razorsql-gui
- functionalities
- view-contents
- view-contents
- view-contents-limit
- edit
- describe
- table-relationships
- search
- copy
- copy-to-another-database
- copy-to-local-database
- backup
- show-info
- row-count
- generate-sql
- generate-ddl
- database-conversion
- create-table
- create-view
- create-index
- alter
- drop
- drop-tables
- export-data
- import-data
- export-tables
- query-builder
- compare-tool
Interview Questions
DB2 RazorSQL ViewA view is used to define an alternative way of representing the data stored in a table. A view is not a real table and doesn't have any permanent storage. It facilitates you to look at the data in one or more tables. It is a named specification of a result table. A VIEW can derived from one or more tables. You can use upto 15 tables to create a VIEW. A VIEW can contain all the columns or a certain columns from the table. View ContentsView contents block facilitates you to see all records stored in the table.  Next TopicView Contents Fetch All Rows
|