Answer Posted / guest
If we have several tables in a db and we want to view only
specific columns from specific tables we can go for views.
It would also suffice the needs of security some times
allowing specfic users to see only specific columns based on
the permission that we can configure on the view. Views also
reduce the effort that is required for writing queries to
access specific columns every time.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain foreign key in sql server?
In how many ways you can invoke ssrs reports?
What are the basic functions for master, msdb, model, tempdb databases?
What are the different ways you can create databases in sql server?
How to get all stored procedures in sql server?
Why I am getting "the microsoft .net framework 2.0 in not installed" message?
What is normalization and its types?
Is sql server free?
How to encrypt Strored Procedure in SQL SERVER?
Difference between connected and disconnected database in .net with sql server?
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?
What is acid db?
Write an SQL query to obtain the 2nd highest salary.
How to list all tables in the database using odbc_tables()?
What language is sql server written in?