adspace


What is schemabinding a view?

Answer Posted / Shiv Kumar

Schemabinding a view in SQL Server means that the view's definition depends on the existence and integrity of other database objects. This prevents the view from being modified in ways that would affect its intended result.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is it possible to have clustered index on separate drive from original table location?

1050


How can I check that whether automatic statistic update is enabled or not?

1121


What is standby servers? Explain types of standby servers.

1089


What is sql server query analyzer?

1137


List the ways in which dynamic sql can be executed?

1099


Where can you add custom error messages to sql server?

1222


List out the different types of locks available in sql server?

1058


How raid can influence database performance?

1127


What is a coalesce function?

1292


If any stored procedure is encrypted, then can we see its definition in activity monitor?

1083


How do I find the sql server version?

1115


How do I find query history in sql server?

1034


What are the different SQL Server Versions you have worked on?

1084


What is in place upgrade in sql server?

1137


How to enter binary string literals in ms sql server?

1256