search

theonesp / p_zero-code

MIT License
2 stars 1 forks source link

Q & A #13

Open xborrat opened 2 years ago

xborrat commented 2 years ago

How views work? The data is automatically update when the source tables are updated? Where is the parsing code stored?

theonesp commented 2 years ago

A VIEW in SQL Server is like a virtual table that contains data from one or multiple tables. It does not hold any data and does not exist physically in the database. Similar to a SQL table, the view name should be unique in a database. It contains a set of predefined SQL queries to fetch data from the database.

xborrat commented 2 years ago

I see, every time I run a query using the view, the query that creates de view is executed too.