Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by VM » view, index and schemabinding!
Add to briefcase

view, index and schemabinding! Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
VM-723206
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: Saturday, April 06, 2013 12:20 AM
Points: 649, Visits: 263
Comments posted to this topic are about the item view, index and schemabinding!
Post #743185
Douglas Acosta-479754
Posted Wednesday, July 01, 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: Wednesday, February 20, 2013 7:39 AM
Points: 563, Visits: 98
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

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.