Sample Header Ad - 728x90

What kind of object is made when we make CREATE VIEW, and what sort of commands can be ran on it?

0 votes
1 answer
23 views
I would like to understand the difference between a table and a View in SQL (Ms Access, if it makes any difference). So I know Create View command can be used to "pull" all fields and records from various tables in a database and present all this data together in one big table. But I don't understand what kind of object View is meant to be, if it isn't a table with data types? And what sort of DML and DDL commands can be executed on View? For example, can commands like DELETE FROM, UPDATE, etc be run on it?
Asked by Sasha1001 (11 rep)
Feb 7, 2022, 12:53 AM
Last activity: Feb 7, 2022, 02:29 AM