What is a view? is View updatable?

Answer Posted / amit upadhyay

VIEW :- VIEW IS VIRTUAL TABLE. WHICH GIVE ACCESS TO SUBSET
OF COLUMN OF THE TABLES.

VIEW CAN BE UPDATED THAT GET EFFECTED THE TABLE ALSO.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are unicode character string data types in ms sql server?

615


How do you check sql server is up and running?

527


How to edit table in sql server 2017?

521


What are the joins in sql server? : sql server database administration

544


How to fetch the next row from a cursor with a "fetch" statement?

600






Tell me about pre-defined functions of sql?

700


Why truncate is ddl command?

522


What are different types of collation sensitivity?

544


How many categories of functions based their return modes?

600


What is difference between rownum and row_number?

529


What is row-level compre?

551


How do you start single user mode in clustered installations?

530


Why I can not enter 0.001 second in date and time literals in ms sql server?

546


How to rebuild indexes with alter index ... Rebuild?

600


how to define testing of network layers? : Sql server database administration

502