Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The IViewOptions class is an interface that represents a collection of options that is associated with a view.
This API is not CLS-compliant. The CLS-compliant alternative is .
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
<StateChangeEventAttribute("ALTER_VIEW", "VIEW")> _
<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.None Or AutomatedPolicyEvaluationMode.Enforce Or AutomatedPolicyEvaluationMode.CheckOnChanges Or AutomatedPolicyEvaluationMode.CheckOnSchedule)> _
<CLSCompliantAttribute(False)> _
<StateChangeEventAttribute("CREATE_VIEW", "VIEW")> _
<StateChangeEventAttribute("RENAME", "VIEW")> _
<StateChangeEventAttribute("ALTER_AUTHORIZATION_DATABASE", "VIEW")> _
<StateChangeEventAttribute("ALTER_SCHEMA", "VIEW")> _
<DisplayNameKeyAttribute("IViewOptions_Name")> _
<LocalizedPropertyResourcesAttribute("Microsoft.SqlServer.Management.Smo.LocalizableResources")> _
<TypeConverterAttribute(GetType(LocalizableTypeConverter))> _
<DisplayDescriptionKeyAttribute("IViewOptions_Desc")> _
Public Interface IViewOptions _
Inherits IDmfFacet
'Usage
Dim instance As IViewOptions
[StateChangeEventAttribute("ALTER_VIEW", "VIEW")]
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode.None|AutomatedPolicyEvaluationMode.Enforce|AutomatedPolicyEvaluationMode.CheckOnChanges|AutomatedPolicyEvaluationMode.CheckOnSchedule)]
[CLSCompliantAttribute(false)]
[StateChangeEventAttribute("CREATE_VIEW", "VIEW")]
[StateChangeEventAttribute("RENAME", "VIEW")]
[StateChangeEventAttribute("ALTER_AUTHORIZATION_DATABASE", "VIEW")]
[StateChangeEventAttribute("ALTER_SCHEMA", "VIEW")]
[DisplayNameKeyAttribute("IViewOptions_Name")]
[LocalizedPropertyResourcesAttribute("Microsoft.SqlServer.Management.Smo.LocalizableResources")]
[TypeConverterAttribute(typeof(LocalizableTypeConverter))]
[DisplayDescriptionKeyAttribute("IViewOptions_Desc")]
public interface IViewOptions : IDmfFacet
[StateChangeEventAttribute(L"ALTER_VIEW", L"VIEW")]
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode::None|AutomatedPolicyEvaluationMode::Enforce|AutomatedPolicyEvaluationMode::CheckOnChanges|AutomatedPolicyEvaluationMode::CheckOnSchedule)]
[CLSCompliantAttribute(false)]
[StateChangeEventAttribute(L"CREATE_VIEW", L"VIEW")]
[StateChangeEventAttribute(L"RENAME", L"VIEW")]
[StateChangeEventAttribute(L"ALTER_AUTHORIZATION_DATABASE", L"VIEW")]
[StateChangeEventAttribute(L"ALTER_SCHEMA", L"VIEW")]
[DisplayNameKeyAttribute(L"IViewOptions_Name")]
[LocalizedPropertyResourcesAttribute(L"Microsoft.SqlServer.Management.Smo.LocalizableResources")]
[TypeConverterAttribute(typeof(LocalizableTypeConverter))]
[DisplayDescriptionKeyAttribute(L"IViewOptions_Desc")]
public interface class IViewOptions : IDmfFacet
[<StateChangeEventAttribute("ALTER_VIEW", "VIEW")>]
[<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.None|AutomatedPolicyEvaluationMode.Enforce|AutomatedPolicyEvaluationMode.CheckOnChanges|AutomatedPolicyEvaluationMode.CheckOnSchedule)>]
[<CLSCompliantAttribute(false)>]
[<StateChangeEventAttribute("CREATE_VIEW", "VIEW")>]
[<StateChangeEventAttribute("RENAME", "VIEW")>]
[<StateChangeEventAttribute("ALTER_AUTHORIZATION_DATABASE", "VIEW")>]
[<StateChangeEventAttribute("ALTER_SCHEMA", "VIEW")>]
[<DisplayNameKeyAttribute("IViewOptions_Name")>]
[<LocalizedPropertyResourcesAttribute("Microsoft.SqlServer.Management.Smo.LocalizableResources")>]
[<TypeConverterAttribute(typeof(LocalizableTypeConverter))>]
[<DisplayDescriptionKeyAttribute("IViewOptions_Desc")>]
type IViewOptions =
interface
interface IDmfFacet
end
public interface IViewOptions extends IDmfFacet
The IViewOptions type exposes the following members.
Properties
Name | Description | |
---|---|---|
![]() |
AnsiNullsStatus | Gets or sets the Boolean value that determines whether ISO null handling is enabled on the view. |
![]() |
CreateDate | Gets the date and time when the view was created. |
![]() |
ID | Gets the ID value that uniquely identifies the view. |
![]() |
IsEncrypted | Indicates whether the view is encrypted. |
![]() |
IsSchemaBound | Gets the Boolean value that determines whether a schema is bound to the view. |
![]() |
IsSchemaOwned | Gets the Boolean value that determines whether the view schema has an owner. |
![]() |
IsSystemObject | Gets the Boolean value that determines whether the view is a system object. |
![]() |
Name | Gets or sets the name of the view. |
![]() |
Owner | Gets the owner of the view options. |
![]() |
QuotedIdentifierStatus | Gets or sets the Boolean value that determines whether identifiers delimited by double quotation marks are Transact-SQL reserved keywords or contain characters not usually allowed by the Transact-SQL syntax rules. |
![]() |
ReturnsViewMetadata | Gets the Boolean value that determines whether the metadata is returned with the view data. |
![]() |
Schema | Gets or sets the schema that is associated with the view options. |
Top