.png)
ExtendedProperty Class
SQL Server 2012
The ExtendedProperty object represents the extended properties that are defined for any object that has an ExtendedProperties collection property.
System::Object
Microsoft.SqlServer.Management.Smo::SmoObjectBase
Microsoft.SqlServer.Management.Smo::SqlSmoObject
Microsoft.SqlServer.Management.Smo::NamedSmoObject
Microsoft.SqlServer.Management.Smo::ScriptNameObjectBase
Microsoft.SqlServer.Management.Smo::ExtendedProperty
Microsoft.SqlServer.Management.Smo::SmoObjectBase
Microsoft.SqlServer.Management.Smo::SqlSmoObject
Microsoft.SqlServer.Management.Smo::NamedSmoObject
Microsoft.SqlServer.Management.Smo::ScriptNameObjectBase
Microsoft.SqlServer.Management.Smo::ExtendedProperty
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
The ExtendedProperty type exposes the following members.
| Name | Description | |
|---|---|---|
.gif?cs-save-lang=1&cs-lang=cpp "Public method") | ExtendedProperty() | Initializes a new instance of the ExtendedProperty class. |
| ExtendedProperty(SqlSmoObject, String) | Initializes a new instance of the ExtendedProperty class with the specified parent and name. |
| ExtendedProperty(SqlSmoObject, String, Object) | Initializes a new instance of the ExtendedProperty class with the specified parent, name, and value. |
| Name | Description | |
|---|---|---|
.gif?cs-save-lang=1&cs-lang=cpp "Public property") | Name | Gets or sets the name of the object. (Inherited from NamedSmoObject.) |
| Parent | Gets or sets the SqlSmoObject object that is the parent of the ExtendedProperty object. |
| Properties | Gets a collection of Property objects that represent the object properties. (Inherited from SqlSmoObject.) |
| State | Gets the state of the referenced object. (Inherited from SmoObjectBase.) |
| Urn | Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (Inherited from SqlSmoObject.) |
| UserData | Gets or sets user-defined data associated with the referenced object. (Inherited from SmoObjectBase.) |
| Value | Gets or sets the string value of the extended property. |
| Name | Description | |
|---|---|---|
| Alter | Updates the extended property on the instance of Microsoft SQL Server with any property changes that have been made to the ExtendedProperty object that it represents. |
| Create | Creates an extended property on the instance of Microsoft SQL Server as defined by the ExtendedProperty object. |
| Discover | Discovers a list of type Object. (Inherited from SqlSmoObject.) |
| Drop | Drops the extended property that is represented by the ExtendedProperty object. |
| Equals | (Inherited from Object.) |
.gif?cs-save-lang=1&cs-lang=cpp "Protected method") | FormatSqlVariant | Formats an object as SqlVariant type. (Inherited from SqlSmoObject.) |
| GetContextDB | Gets the context database that is associated with this object. (Inherited from SqlSmoObject.) |
| GetDBName | Gets the database name that is associated with the object. (Inherited from SqlSmoObject.) |
| GetHashCode | (Inherited from Object.) |
| GetPropValue | Gets a property value of the SqlSmoObject object. (Inherited from SqlSmoObject.) |
| GetPropValueOptional | Gets a property value of the SqlSmoObject object. (Inherited from SqlSmoObject.) |
| GetPropValueOptionalAllowNull | Gets a property value of the SqlSmoObject object. (Inherited from SqlSmoObject.) |
| GetServerObject | Gets the server of the SqlSmoObject object. (Inherited from SqlSmoObject.) |
| GetType | (Inherited from Object.) |
| Initialize() | Initializes the object and forces the properties be loaded. (Inherited from SqlSmoObject.) |
| Initialize(Boolean) | Initializes the object and forces the properties be loaded. (Inherited from SqlSmoObject.) |
| IsObjectInitialized | Verifies whether the object has been initialized. (Inherited from SqlSmoObject.) |
| IsObjectInSpace | Verifies whether the object is isolated or connected to the instance of SQL Server. (Inherited from SqlSmoObject.) |
| MarkForDrop | Marks the object so that it will be dropped the next time the Alter method is called for its parent object. |
| Refresh | Refreshes the script name. (Inherited from ScriptNameObjectBase.) |
| Script() | Generates a Transact-SQL script that can be used to re-create the extended property. |
| Script(ScriptingOptions) | Generates a Transact-SQL script that can be used to re-create the extended property as specified by the script options. |
| SetParentImpl | Sets the parent of the SqlSmoObject to the newParent parameter. (Inherited from SqlSmoObject.) |
| ToString | Returns a String that represents the referenced object. (Inherited from SqlSmoObject.) |
| Validate | Validates the state of an object. (Inherited from SmoObjectBase.) |
| Name | Description | |
|---|---|---|
.gif?cs-save-lang=1&cs-lang=cpp "Public event") | PropertyChanged | Represents the event that occurs when a property is changed. (Inherited from SqlSmoObject.) |
| PropertyMetadataChanged | Represents the event that occurs when property metadata changes. (Inherited from SqlSmoObject.) |
| Name | Description | |
|---|---|---|
.gif?cs-save-lang=1&cs-lang=cpp "Explicit interface implemetation") .gif?cs-save-lang=1&cs-lang=cpp "Private method") | IAlienObject::Discover | Discovers any dependencies. Do not reference this member directly in your code. It supports the SQL Server infrastructure. (Inherited from SqlSmoObject.) |
| IAlienObject::GetDomainRoot | Returns the root of the domain. (Inherited from SqlSmoObject.) |
| IAlienObject::GetParent | Gets the parent of this object. Do not reference this member directly in your code. It supports the SQL Server infrastructure. (Inherited from SqlSmoObject.) |
| IAlienObject::GetPropertyType | Gets the type of the specified property. (Inherited from SqlSmoObject.) |
| IAlienObject::GetPropertyValue | Gets the value of the specified property. (Inherited from SqlSmoObject.) |
| IAlienObject::GetUrn | Gets the Unified Resource Name (URN) of the object. Do not reference this member directly in your code. It supports the SQL Server infrastructure. (Inherited from SqlSmoObject.) |
| IAlienObject::Resolve | Gets the instance that contains the information about the object from the Unified Resource Name (URN) of the object. (Inherited from SqlSmoObject.) |
| IAlienObject::SetObjectState | Sets the object state to the specified SfcObjectState value. (Inherited from SqlSmoObject.) |
| IAlienObject::SetPropertyValue | Sets the property value. (Inherited from SqlSmoObject.) |
| ISfcPropertyProvider::GetPropertySet | Gets the interface reference to the set of properties of this object. (Inherited from SqlSmoObject.) |
