Why use view instead of a table?
Answer / Vineet Kumar Garg
Views are used in SQL Server as virtual tables that do not store data themselves, but are simply SELECT statements that can be queried. They are useful for security (hiding sensitive data), simplifying complex queries, and enforcing data integrity rules.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is deadlock and how to avoid the deadlocks.
If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio
Does full backup break log chain?
Does partitioning ssd reduce performance?
What is the datatype returned by count(*)
22 Answers 247Customer, Asian CERC,
What does truncate do?
Why variables called the most powerful component of ssis?
What is sql server locking?
What is the difference between char and varchar2 datatype in sql?
Explain datetime2 data type in sal server 2008?
You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?
How to create an index on a view?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)