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
Last activity: Feb 7, 2022, 02:29 AM