• Article

SqlSmoObject Members

Include Protected Members
Include Inherited Members

The SqlSmoObject object represents all SQL Server objects.

The SqlSmoObject type exposes the following members.

Constructors

  Name Description
Protected method SqlSmoObject() Initializes a new instance of the SqlSmoObject class.

Top

Methods

  Name Description
Protected method AddDatabaseContext(StringCollection)
Protected method AlterImpl()
Protected method AlterImplFinish(StringCollection, ScriptingOptions)
Protected method AlterImplInit(StringCollection%, ScriptingOptions%)
Protected method AlterImplWorker()
Protected method BindDefaultImpl(String, String, Boolean)
Protected method BindRuleImpl(String, String, Boolean)
Protected method CheckCollation(String, ScriptingOptions)
Protected method CheckObjectState() Validates the state of the referenced object.
Protected method CheckObjectState(Boolean) Validates the state of the referenced object with the option to specify that an exception is thrown if the object is not yet created.
Protected method CheckObjectStateImpl(Boolean)
Protected method CheckVersion100()
Protected method CheckVersion80() Checks the validity of the object on SQL Server 2000.
Protected method CheckVersion80SP3() Checks the validity of the object on SQL Server 2000 SP3.
Protected method CheckVersion90() Check the validity of the object on SQL Server 2005.
Protected method CheckVersionBelow90()
Protected method CleanObject()
Protected method CreateImpl()
Protected method CreateImplFinish(StringCollection, ScriptingOptions)
Protected method CreateImplInit(StringCollection%, ScriptingOptions%)
Public method Discover()
Protected method DropImpl()
Protected method DropImplWorker(Urn%)
Protected method EnumScriptImpl(ScriptingOptions)
Protected method EnumScriptImplWorker(ScriptingOptions)
Public method Equals(Object) (Inherited from Object.)
Protected method Finalize() (Inherited from Object.)
Protected method FormatSqlVariant(Object)
Protected method GenerateDataSpaceFileStreamScript(StringBuilder, ScriptingOptions, Boolean)
Protected method GenerateDataSpaceScript(StringBuilder, ScriptingOptions)
Protected method GetBindDefaultScript(ScriptingOptions, String, String, Boolean)
Protected method GetBindRuleScript(ScriptingOptions, String, String, Boolean)
Protected method GetBoolParameter(StringBuilder, ScriptingOptions, String, String, Int32%)
Protected method GetBoolParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean)
Public methodStatic member GetChildType(String, String)
Protected method GetDateTimeParameter(StringBuilder, ScriptingOptions, String, String, Int32%)
Protected method GetDateTimeParameterAsInt(StringBuilder, ScriptingOptions, String, String, Int32%)
Protected method GetDBName() Gets the database name that is associated with the object.
Protected method GetEnumParameter(StringBuilder, ScriptingOptions, String, String, Type, Int32%)
Protected method GetFragOptionString(FragmentationOption)
Protected method GetGuidParameter(StringBuilder, ScriptingOptions, String, String, Int32%)
Public method GetHashCode() (Inherited from Object.)
Protected method GetParameter(StringBuilder, ScriptingOptions, String, String, Int32%)
Protected method GetParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean)
Protected method GetPropValue(String)
Protected method GetPropValueOptional(String)
Protected method GetPropValueOptionalAllowNull(String)
Protected method GetRealValue(Property, Object)
Protected method GetScriptingOptionsForCreate()
Protected method GetServerName() Gets the name of the instance of SQL Server with which the object is associated.
Protected method GetServerObject()
Protected method GetSqlServerVersionName() Gets the version name of the instance of SQL Server with which the object is associated.
Protected method GetStringParameter(StringBuilder, ScriptingOptions, String, String, Int32%)
Protected method GetStringParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean)
Protected method GetTimeSpanParameterAsInt(StringBuilder, ScriptingOptions, String, String, Int32%)
Public method GetType() (Inherited from Object.)
Public methodStatic member GetTypeFromUrnSkeleton(Urn)
Protected method GetUrnRecursive(StringBuilder)
Protected method GetUrnRecursive(StringBuilder, UrnIdOption)
Protected method ImplInitialize(array<String[], array<OrderBy[])
Public method Initialize() Initializes the object and forces the properties be loaded.
Public method Initialize(Boolean) Initializes the object and forces the properties be loaded.
Protected methodStatic member IsCollectionDirty(ICollection)
Protected method IsObjectDirty() Verifies whether the object properties have been modified and the changes have not yet been persisted on the instance of SQL Server.
Protected method IsObjectInitialized() Verifies whether the object has been initialized.
Protected method IsObjectInSpace() Verifies whether the object is isolated or connected to the instance of SQL Server.
Protected method IsVersion80SP3()
Protected method MarkDropped()
Protected method MarkForDropImpl(Boolean)
Protected method MemberwiseClone() (Inherited from Object.)
Protected method PostAlter()
Protected method PostCreate()
Protected method PostDrop()
Public method Refresh() Refreshes the object and retrieves properties when the object is next accessed.
Protected method ScriptAlter(StringCollection, ScriptingOptions)
Protected method ScriptCreate(StringCollection, ScriptingOptions)
Protected method ScriptDdl(StringCollection, ScriptingOptions)
Protected method ScriptDrop(StringCollection, ScriptingOptions)
Protected method ScriptImpl()
Protected method ScriptImpl(ScriptingOptions)
Protected method ScriptImplWorker(ScriptingOptions)
Protected method SetParentImpl(SqlSmoObject)
Public method ToString() Returns a String that represents the referenced object. (Overrides Object.ToString().)
Protected method TouchImpl()
Protected methodStatic member Trace(String) Traces the object.
Protected method UnbindDefaultImpl(Boolean)
Protected method UnbindRuleImpl(Boolean)
Protected methodStatic member UpdateCollectionState2(ICollection)
Public method Validate(String, array<Object[]) (Inherited from SmoObjectBase.)

Top

Fields

  Name Description
Protected field m_ExtendedProperties

Top

Properties

  Name Description
Protected property ExecuteForScalar Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option.
Protected property IsTouched Gets the Boolean property value that specifies whether the object properties have been updated but not yet persisted on the server.
Protected property ObjectInSpace Gets the Boolean property value that specifies whether the object exists in isolation, or whether it is directly or indirectly connected to the instance of SQL Server.
Public property Properties Gets a collection of Property objects that represent the object properties.
Protected property ScalarResult Gets the scalar result for the referenced object.
Public property State Gets the state of the referenced object. (Inherited from SmoObjectBase.)
Public property Urn Gets the Uniform Resource Name (URN) address value that uniquely identifies the object.
Public property UserData Gets or sets user-defined data associated with the referenced object. (Inherited from SmoObjectBase.)

Top

Events

  Name Description
Public event PropertyChanged
Public event PropertyMetadataChanged

Top