Aug 21, 2006 #1 Luzian Programmer Nov 27, 2005 103 US Other than locking the alteration of tables referenced in a view created with schemabinding, why else is it used?
Other than locking the alteration of tables referenced in a view created with schemabinding, why else is it used?
Aug 21, 2006 #2 SQLDenis Programmer Oct 1, 2005 5,575 US if you want to create an indexed view then the view and any user defined functions referenced by the view have to be created with SCHEMABINDING Denis The SQL Menace SQL blog:http://sqlservercode.blogspot.com/ Personal Blog:http://otherthingsnow.blogspot.com/ Upvote 0 Downvote
if you want to create an indexed view then the view and any user defined functions referenced by the view have to be created with SCHEMABINDING Denis The SQL Menace SQL blog:http://sqlservercode.blogspot.com/ Personal Blog:http://otherthingsnow.blogspot.com/