What is difference between Table and View in DB2?

RDBMS from IBM and IBM's Hierarchical DBMS and Transaction Manager (IMS DC).
Post Reply
utkarsh
Registered Member
Posts: 64
Joined: Fri Jun 21, 2013 10:32 pm

What is difference between Table and View in DB2?

Post by utkarsh »

What is the exact difference between Table and View - I get confused...
User avatar
Anuj Dhawan
Founder
Posts: 2799
Joined: Sun Apr 21, 2013 7:40 pm
Location: Mumbai, India
Contact:
India

Re: What is difference between Table and View in DB2?

Post by Anuj Dhawan »

In very simple words - Tables are the actual database entities that hold your rows while views are "imaginary" tables that are constructed based on the actual tables.
Thanks,
Anuj

Disclaimer: My comments on this website are my own and do not represent the opinions or suggestions of any other person or business entity, in any way.
Post Reply

Create an account or sign in to join the discussion

You need to be a member in order to post a reply

Create an account

Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute

Register

Sign in

Return to “IBM DB2 and IMS DB/DC”