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
How to create database with physical files specified in ms sql server?
How to write a query with a left outer join in ms sql server?
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
How can you check the level of fragmentation on a table?
What is an execution plan?
List the data types available in mssql?
What is linked report?
How do you test your database? : sql server database administration
how to overcome kernel isssues
How to verify the port number of the sql server?
How to get a list of columns in a view using "sys.columns" in ms sql server?
What is a raid and what are different types of raid configurations?
How to delete a database in ms sql server?
Which rendering formats are affected by the pagesize properties?
What is the syntax for encrypting a column in SQL Server?
