Content reflects changes to the underlying table , but its membership and ordering remain static . the dynamic capabilities of the 数组,虽然其内容反映对基础表的更改,但其成员关系和排序却则保持静态。
Specifies whether underlying tables and associated indexes are available for queries and data modification during the index operation 指定在索引操作期间基础表和关联的索引是否可用于查询和数据修改操作。
After you deploy an application , changing the event or notification schema will drop and re - create the underlying tables and views 在部署应用程序之后,更改事件或通知架构将会删除并重新创建基础表和视图。
Clustered indexes must be created , rebuilt , or dropped offline when the underlying table contains large object data types 如果基础表包含下列大型对象( lob )数据类型,则必须创建、重新生成或脱机删除聚集索引:
Counter indicates the level of maintenance on the index caused by insert , update , or delete operations on the underlying table or view 计数器指示由基础表或视图上的插入、更新或删除操作所引起的索引维护级别。
This issue does not affect locally partitioned views , such as when all the underlying tables exist on the same instance of sql server 此问题不会影响本地分区视图,例如,当所有基础表都在同一sql server实例上时。
Any updates performed directly to a view s underlying tables are not verified against the view , even if check option is specified 即使指定了check option ,也不能依据视图来验证任何直接对视图的基础表执行的更新。
If no location is specified and the table or view is not partitioned , the index uses the same filegroup as the underlying table or view 如果未指定位置且表或视图尚未分区,则索引将与基础表或视图使用相同的文件组。
Insert statements must specify values for any columns in the underlying table that do not allow null values and have no default definitions Insert语句必须为不允许空值并且没有default定义的基础表中的所有列指定值。
Additionally , all lob columns that are associated with the clustered index , underlying table , or nonclustered index with included columns are compacted 此外,将压缩与聚集索引、基础表或带有包含性列的非聚集索引关联的所有lob列。