Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

view, index and schemabinding! Expand / Collapse
Author
Message
Posted Saturday, June 27, 2009 4:27 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Thursday, December 11, 2014 5:11 AM
Points: 654, Visits: 267
Comments posted to this topic are about the item view, index and schemabinding!
Post #743185
Posted Wednesday, July 1, 2009 9:52 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, November 4, 2014 12:48 PM
Points: 564, Visits: 99
According to the "Create Indexed Views" link you sent, the first part says

"A view must meet the following requirements before you can create a clustered index on it:

...
The view must be created with the SCHEMABINDING option. Schema binding binds the view to the schema of the underlying base tables.
..."

Since a view can contain non-clustered indexes the statement is False, am I right?
Post #745556
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse