문서를 영문으로 보려면 영문 확인란을 선택하세요. 마우스 포인터를 텍스트 위로 이동시켜 팝업 창에서 영문 텍스트를 표시할 수도 있습니다.
번역
영문

Index 속성

Index 유형에서 다음 멤버를 표시합니다.

  이름 설명
공용 속성 BoundingBoxXMax Specifies the x-coordinate of the upper right corner of a bounding box.
공용 속성 BoundingBoxXMin Specifies the x-coordinate of the lower-left corner of a bounding box.
공용 속성 BoundingBoxYMax Specifies the y-coordinate of upper-right corner of a bounding box.
공용 속성 BoundingBoxYMin Specifies the y-coordinate of the lower-left corner of a bounding box.
공용 속성 CellsPerObject Defines the maximum number of cells that tessellation can count per object.
공용 속성 CompactLargeObjects Gets or sets the Boolean property value that specifies whether to compact the large object (LOB) data in the index.
공용 속성 DisallowPageLocks Gets or sets the Boolean property value that specifies whether the index allows page locks.
공용 속성 DisallowRowLocks Gets or sets the Boolean property value that specifies whether the index allows row locks.
공용 속성 Events Gets the index events supported by the Index object.
공용 속성 ExtendedProperties Represents a collection of ExtendedProperty objects. Each ExtendedProperty object represents an extended property defined on the Index object.
공용 속성 FileGroup Gets or sets the filegroup where the index pages are stored.
공용 속성 FileStreamFileGroup Gets or Sets the file group name for the index.
공용 속성 FileStreamPartitionScheme Gets or Sets the partition scheme name for the index.
공용 속성 FillFactor Gets or sets the percentage of an index page to fill when the index is created or re-created.
공용 속성 FilterDefinition Gets or sets the String value that contains the definition for the filter.
공용 속성 HasCompressedPartitions Gets or sets the Boolean property value that specifies whether the index has compressed partitions.
공용 속성 HasFilter Gets the Boolean property value that specifies whether the index has a filter defined for a range of index values.
공용 속성 ID Gets the index ID value that uniquely identifies the index within the database.
공용 속성 IgnoreDuplicateKeys Gets or sets the Boolean property value that specifies whether the index ignores duplicate keys.
공용 속성 IndexedColumns Gets a collection of IndexedColumn objects that represent all the columns participating in the index.
공용 속성 IndexedXmlPathName Gets or sets the name of the indexed XML path.
공용 속성 IndexedXmlPathNamespaces Gets the collection of indexed XML path namespace.
공용 속성 IndexedXmlPaths Gets or sets the collection of indexed XML paths.
공용 속성 IndexKeyType Gets or sets the index key type.
공용 속성 IndexType Gets or sets the type of index.
공용 속성 IsClustered Gets or sets the Boolean property value that specifies whether the index is clustered.
공용 속성 IsDisabled Gets or sets the Boolean property value that specifies whether the index is disabled.
공용 속성 IsFileTableDefined Gets or sets whether the file table is defined.
공용 속성 IsFullTextKey Gets the Boolean value that specifies whether the index is enabled for row identification in Microsoft Search.
공용 속성 IsIndexOnComputed Gets the Boolean property value that specifies whether the index is based on a computed column.
공용 속성 IsIndexOnTable Gets the Boolean property value that specifies whether the index is defined for a table or a view.
공용 속성 IsPartitioned Gets the Boolean property value that specifies whether the index is stored in a partitioned scheme.
공용 속성 IsSpatialIndex Gets a value that indicates whether an index is a spatial index.
공용 속성 IsSystemNamed Gets the Boolean property value that specifies whether the index was named automatically by the system.
공용 속성 IsSystemObject Gets the Boolean property value that specifies whether the index is a system object.
공용 속성 IsUnique Gets or sets the Boolean property value that specifies whether the index is unique or not.
공용 속성 IsXmlIndex Gets or sets the Boolean property value that specifies whether the index is an XML index.
공용 속성 Level1Grid Gets or sets the first level of decomposition for a geometry data type.
공용 속성 Level2Grid Specifies the second level of decomposition for a geometry data type.
공용 속성 Level3Grid Specifies the third level of decomposition for a geometry data type.
공용 속성 Level4Grid Gets or sets the fourth level of decomposition for a geometry data type.
공용 속성 MaximumDegreeOfParallelism Gets or sets the maximum number of processors that can be used when running a query that uses the index.
공용 속성 Name Gets or sets the name of the index. (NamedSmoObject.Name을(를) 재정의함)
공용 속성 NoAutomaticRecomputation Gets or sets the Boolean property value that specifies whether statistics are regenerated when an index is created.
공용 속성 OnlineIndexOperation Gets or sets the Boolean property value that specifies whether the index will be kept online during index operations thus allowing access to the data.
공용 속성 PadIndex Gets or sets the Boolean property value that specifies whether space is left open on each page of the intermediate levels of the index.
공용 속성 Parent Gets or sets the SqlSmoObject object that is the parent of the Index object.
공용 속성 ParentXmlIndex Gets or sets the parent of an XML index.
공용 속성 PartitionScheme Gets or sets the partition scheme associated with the index.
공용 속성 PartitionSchemeParameters Represents a collection of PartitionSchemeParameter objects. Each PartitionSchemeParameter object represents a parameter in the partition scheme associated with the index.
공용 속성 PhysicalPartitions Gets a collection of PhysicalPartition objects that represent all the physical partitions on which the index is stored.
공용 속성 Properties Gets a collection of Property objects that represent the object properties. (SqlSmoObject에서 상속됨)
공용 속성 SecondaryXmlIndexType Gets or sets the secondary XML index type.
공용 속성 SortInTempdb Gets or sets the Boolean property value that specifies whether the index is sorted using the tempdb database for intermediate storage of data.
공용 속성 SpaceUsed Gets or sets the disk space used to store the index data in kilobytes.
공용 속성 SpatialIndexType Gets or sets the Spatial Index Type for a column.
공용 속성 State Gets the state of the referenced object. (SmoObjectBase에서 상속됨)
공용 속성 Urn Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (SqlSmoObject에서 상속됨)
공용 속성 UserData Gets or sets user-defined data associated with the referenced object. (SmoObjectBase에서 상속됨)
맨 위로 이동

  이름 설명
명시적 인터페이스 구현 전용 속성 ISfcSupportsDesignMode.IsDesignMode Gets a Boolean value that indicates whether the object supports design mode.
맨 위로 이동

커뮤니티 추가 항목

추가
표시: