Forum Moderators: phranque

Message Too Old, No Replies

New to Enterprise Manager

and SQL

         

Skylo

9:01 am on Jul 13, 2004 (gmt 0)

10+ Year Member



Just a quick one:) Seeing how bad the help function is, could someone please tell me the exact difference between a databases tables and its views.
They look exactly the same and i am confused
Thanks everyone for bearing with me:)

Red_Eye

9:12 am on Jul 13, 2004 (gmt 0)

10+ Year Member



A database table is where the information is stored. A view is just that a view of the information stored in a table. So if you only want to show the ID, First name and Last name fields you You would create a view of the table in question and add those fields to the view. You can also join field values to gether create calculation fields etc.

If you have used Access it is similar to queries.