Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

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