Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

View Properties

The View type exposes the following members.

  Name Description
Public property AnsiNullsStatus Gets the Boolean property value that specifies whether ISO NULL handling is enabled on the view.
Public property Columns Gets a column collection. (Inherited from TableViewTableTypeBase.)
Public property CreateDate Gets the time and date when the view was created.
Public property DateLastModified Gets the time and date when the view was last modified.
Public property Events Gets the events associated with the view.
Public property ExtendedProperties Gets an extended property collection. (Inherited from TableViewTableTypeBase.)
Public property FullTextIndex Gets the full text index on the table or view. (Inherited from TableViewBase.)
Public property HasAfterTrigger Gets the Boolean property value that specifies whether the view has any after triggers.
Public property HasColumnSpecification Gets the Boolean property that specifies whether the view has a column specification.
Public property HasDeleteTrigger Gets the Boolean property value that specifies whether the view has a delete trigger.
Public property HasIndex Gets the Boolean property value that specifies whether the view has at least one index.
Public property HasInsertTrigger Gets the Boolean property value that specifies whether the view has an insert trigger.
Public property HasInsteadOfTrigger Gets the Boolean property value that specifies whether the view has any instead of triggers.
Public property HasUpdateTrigger Gets the Boolean property value that specifies whether the view has at least one update trigger.
Public property ID Gets the ID value that uniquely identifies the view.
Public property Indexes Gets the IndexCollection object. (Overrides TableViewTableTypeBase.Indexes.)
Public property IsEncrypted Gets or sets the Boolean property that specifies whether the view is encrypted.
Public property IsIndexable Gets the Boolean property that specifies whether it is possible to place an index on the view.
Public property IsSchemaBound Gets or sets the Boolean property that specifies whether a schema is bound to the view.
Public property IsSchemaOwned Gets a Boolean value that indicates whether the View object is owned by a schema.
Public property IsSystemObject Gets the Boolean property value that specifies whether the view is a system object.
Public property Name Gets or sets a String value that specifies the name of the view table type. (Inherited from TableViewTableTypeBase.)
Public property Owner Gets the name of the owner of the UserDefinedType object.
Public property Parent Gets the Database object that is the parent of the View object.
Public property Properties Gets a collection of Property objects that represent the object properties. (Inherited from SqlSmoObject.)
Public property QuotedIdentifierStatus 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.
Public property ReturnsViewMetadata Gets or sets a Boolean property value that specifies whether the view returns metadata.
Public property Schema Gets or sets a String value that specifies the name of the schema that contains the view table type. (Inherited from TableViewTableTypeBase.)
Public property State Gets the state of the referenced object. (Inherited from SmoObjectBase.)
Public property Statistics Represents a collection of Statistic objects. Each Statistic object represents a statistic counter that is defined on the table or view. (Inherited from TableViewBase.)
Public property TextBody Gets or sets the Transact-SQL string that defines the view.
Public property TextHeader Gets or sets the header part of the Transact-SQL string that defines the view.
Public property TextMode Gets or sets the Boolean property that specifies whether the text header is editable as text.
Public property Triggers Represents a collection of Trigger objects. Each Trigger object represents a trigger that is defined on the table or view. (Inherited from TableViewBase.)
Public property Urn Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (Inherited from SqlSmoObject.)
Public property UserData Gets or sets user-defined data associated with the referenced object. (Inherited from SmoObjectBase.)
Top
  Name Description
Explicit interface implemetation Private property ISfcSupportsDesignMode.IsDesignMode Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. Gets a Boolean value that indicates whether the object supports design mode.
Top
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.