newbie: table versus view? where is the table
Posted on 2006-06-06
I do not understand "views", but I do know that the DB I am working on has a couple hundred tables. I can see them, query them, update them, restore them, etc.. Every table I have seen in a query is actually a table except one. The "Employees" table is nowhere to be found, except under "Views" (Enterprise Manager). But it seems to reference the Employees table, no? Here's my question: where is the table? Is there one?
Here is what shows up under Views:
create view [view Employees] as select Employees.employee_number [Employee Number],Employees.first_name [First Name],Employees.last_name [Last Name],Employees.ss_number [SS Number] from Employees
Thanks for any help.