Whether the updations made to the views reflect the
original records in the table
Answers were Sorted based on User's Feedback
Answer / sabareetha
If the view is created with single table. Updating a view
will affect the origival records in the table
Is This Answer Correct ? | 12 Yes | 2 No |
Answer / ravi sharma
in the case if same table (all column) are make a view then
updations reflect the original record in the table.
but mostly make a view to security purpose the , uniques
are constaint column are not use,
then not be reflect .
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / soorai ganesh
No. Updating View will not affect the table records.
Is This Answer Correct ? | 9 Yes | 13 No |
where can you add custom error messages to sql server? : Sql server administration
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
last function used in MS Access to convert sql what function will use in sql
What is difference between restoration and recovery in SQLServer?
how can i store resumes in database?
i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only duplicates no.
hi i gone though satyam interview. what is Acid Properties?
How to end a stored procedure properly in ms sql server?
You want to implement the one-to-one relationship while designing tables. How would you do it?
Which Model uses the SET concept
What is sql sandbox in sql server?
How to change a login name in ms sql server?