Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
MSDN Library

View Properties

 

Applies To: SQL Server 2016 Preview

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

NameDescription
System_CAPS_pubpropertyAnsiNullsStatus

Gets the Boolean property value that specifies whether ISO NULL handling is enabled on the view.

System_CAPS_pubpropertyColumns

Gets a column collection.(Inherited from TableViewTableTypeBase.)

System_CAPS_pubpropertyCreateDate

Gets the time and date when the view was created.

System_CAPS_pubpropertyDateLastModified

Gets the time and date when the view was last modified.

System_CAPS_pubpropertyEvents

Gets the events associated with the view.

System_CAPS_pubpropertyExtendedProperties

Gets an extended property collection.(Inherited from TableViewTableTypeBase.)

System_CAPS_pubpropertyFullTextIndex

Gets the full text index on the table or view.(Inherited from TableViewBase.)

System_CAPS_pubpropertyHasAfterTrigger

Gets the Boolean property value that specifies whether the view has any after triggers.

System_CAPS_pubpropertyHasColumnSpecification

Gets the Boolean property that specifies whether the view has a column specification.

System_CAPS_pubpropertyHasDeleteTrigger

Gets the Boolean property value that specifies whether the view has a delete trigger.

System_CAPS_pubpropertyHasIndex

Gets the Boolean property value that specifies whether the view has at least one index.

System_CAPS_pubpropertyHasInsertTrigger

Gets the Boolean property value that specifies whether the view has an insert trigger.

System_CAPS_pubpropertyHasInsteadOfTrigger

Gets the Boolean property value that specifies whether the view has any instead of triggers.

System_CAPS_pubpropertyHasUpdateTrigger

Gets the Boolean property value that specifies whether the view has at least one update trigger.

System_CAPS_pubpropertyID

Gets the ID value that uniquely identifies the view.

System_CAPS_pubpropertyIndexes

Gets the IndexCollection object. (Overrides TableViewTableTypeBase.Indexes.)

System_CAPS_pubpropertyIsEncrypted

Gets or sets the Boolean property that specifies whether the view is encrypted.

System_CAPS_pubpropertyIsIndexable

Gets the Boolean property that specifies whether it is possible to place an index on the view.

System_CAPS_pubpropertyIsSchemaBound

Gets or sets the Boolean property that specifies whether a schema is bound to the view.

System_CAPS_pubpropertyIsSchemaOwned

Gets a Boolean value that indicates whether the View object is owned by a schema.

System_CAPS_pubpropertyIsSystemObject

Gets the Boolean property value that specifies whether the view is a system object.

System_CAPS_pubpropertyName

Gets or sets a String value that specifies the name of the view table type.(Inherited from TableViewTableTypeBase.)

System_CAPS_pubpropertyOwner

Gets the name of the owner of the UserDefinedType object.

System_CAPS_pubpropertyParent

Gets the Database object that is the parent of the View object.

System_CAPS_pubpropertyProperties

Gets a collection of Property objects that represent the object properties.(Inherited from SqlSmoObject.)

System_CAPS_pubpropertyQuotedIdentifierStatus

Gets or sets a Boolean property value that specifies whether identifiers delimited by double quotation marks are Transact-SQL reserved keywords or contain characters not usually allowed by the Transact-SQL syntax rules.

System_CAPS_pubpropertyReturnsViewMetadata

Gets or sets a Boolean property value that specifies whether the view returns metadata.

System_CAPS_pubpropertySchema

Gets or sets a String value that specifies the name of the schema that contains the view table type.(Inherited from TableViewTableTypeBase.)

System_CAPS_pubpropertyState

Gets the state of the referenced object.(Inherited from SmoObjectBase.)

System_CAPS_pubpropertyStatistics

Represents a collection of Statistic objects. Each Statistic object represents a statistic counter that is defined on the table or view.(Inherited from TableViewBase.)

System_CAPS_pubpropertyTextBody

Gets or sets the Transact-SQL string that defines the view.

System_CAPS_pubpropertyTextHeader

Gets or sets the header part of the Transact-SQL string that defines the view.

System_CAPS_pubpropertyTextMode

Gets or sets the Boolean property that specifies whether the text header is editable as text.

System_CAPS_pubpropertyTriggers

Represents a collection of Trigger objects. Each Trigger object represents a trigger that is defined on the table or view.(Inherited from TableViewBase.)

System_CAPS_pubpropertyUrn

Gets the Uniform Resource Name (URN) address value that uniquely identifies the object.(Inherited from SqlSmoObject.)

System_CAPS_pubpropertyUserData

Gets or sets user-defined data associated with the referenced object.(Inherited from SmoObjectBase.)

Return to top
Show:
© 2015 Microsoft