Membri Column

The Column object represents a SQL Server column.

Il tipo Column espone i membri seguenti.

Costruttori

	Nome	Descrizione
	Column() () () ()	Initializes a new instance of the Column class.
	Column(SqlSmoObject, String)	Initializes a new instance of the Column class that has the specified parent and specified name.
	Column(SqlSmoObject, String, DataType)	Initializes a new instance of the Column class that has the specified parent and specified name.
	Column(SqlSmoObject, String, DataType, Boolean)	Initializes a new instance of the Column class that uses the specified parent, datayype, and optionally adding the FILESTREAM attribute.

In alto

Metodi

	Nome	Descrizione
	AddDatabaseContext	(Ereditato da SqlSmoObject).
	AddDefaultConstraint() () () ()	Adds a default constraint to the column.
	AddDefaultConstraint(String)	Adds a default constraint to the column.
	Alter	Updates any Column object property changes on the instance of SQL Server.
	AlterImpl	(Ereditato da SqlSmoObject).
	AlterImplFinish	(Ereditato da SqlSmoObject).
	AlterImplInit	(Ereditato da SqlSmoObject).
	AlterImplWorker	(Ereditato da SqlSmoObject).
	AppendCommaText	(Ereditato da ScriptNameObjectBase).
	AppendWithCommaText	(Ereditato da ScriptNameObjectBase).
	AppendWithOption	(Ereditato da ScriptNameObjectBase).
	BindDefault	Binds a default to the column.
	BindDefaultImpl	(Ereditato da SqlSmoObject).
	BindRule	Binds a rule to the column.
	BindRuleImpl	(Ereditato da SqlSmoObject).
	CheckCollation	(Ereditato da SqlSmoObject).
	CheckObjectDirty	(Ereditato da ScriptNameObjectBase).
	CheckObjectState() () () ()	Validates the state of the referenced object. (Ereditato da SqlSmoObject).
	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. (Ereditato da SqlSmoObject).
	CheckObjectStateImpl	(Ereditato da SqlSmoObject).
	CheckTextCorectness	(Ereditato da ScriptNameObjectBase).
	CheckTextModeSupport	(Ereditato da ScriptNameObjectBase).
	CheckVersion100	(Ereditato da SqlSmoObject).
	CheckVersion80	Checks the validity of the object on SQL Server 2000. (Ereditato da SqlSmoObject).
	CheckVersion80SP3	Checks the validity of the object on SQL Server 2000 SP3. (Ereditato da SqlSmoObject).
	CheckVersion90	Check the validity of the object on SQL Server 2005. (Ereditato da SqlSmoObject).
	CheckVersionBelow90	(Ereditato da SqlSmoObject).
	CleanObject	Cleans the referenced object. (Ereditato da ScriptNameObjectBase).
	Create	Creates a column on the instance of Microsoft SQL Server as defined by the Column object.
	CreateImpl	(Ereditato da SqlSmoObject).
	CreateImplFinish	(Ereditato da SqlSmoObject).
	CreateImplInit	(Ereditato da SqlSmoObject).
	Discover	(Ereditato da SqlSmoObject).
	Drop	Drops the column.
	DropImpl	(Ereditato da SqlSmoObject).
	DropImplWorker	(Ereditato da SqlSmoObject).
	EnumForeignKeys	Enumerates a list of foreign keys that reference the column.
	EnumIndexes	Enumerates a list of indexes that include the column.
	EnumScriptImpl	(Ereditato da SqlSmoObject).
	EnumScriptImplWorker	(Ereditato da SqlSmoObject).
	EnumUserPermissions	Enumerates a list of permissions for a specified user.
	Equals	(Ereditato da Object).
	Finalize	(Ereditato da Object).
	ForceTextModeOnTextBody	Enforces text mode on the text body. (Ereditato da ScriptNameObjectBase).
	FormatSqlVariant	(Ereditato da SqlSmoObject).
	GenerateDataSpaceFileStreamScript	(Ereditato da SqlSmoObject).
	GenerateDataSpaceScript	(Ereditato da SqlSmoObject).
	GetBindDefaultScript	(Ereditato da SqlSmoObject).
	GetBindRuleScript	(Ereditato da SqlSmoObject).
	GetBoolParameter(StringBuilder, ScriptingOptions, String, String, Int32%)	(Ereditato da SqlSmoObject).
	GetBoolParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean)	(Ereditato da SqlSmoObject).
	GetBraketNameForText	(Ereditato da ScriptNameObjectBase).
	GetDateTimeParameter	(Ereditato da SqlSmoObject).
	GetDateTimeParameterAsInt	(Ereditato da SqlSmoObject).
	GetDBName	Gets the database name that is associated with the object. (Ereditato da SqlSmoObject).
	GetEnumParameter	(Ereditato da SqlSmoObject).
	GetFragOptionString	(Ereditato da SqlSmoObject).
	GetGuidParameter	(Ereditato da SqlSmoObject).
	GetHashCode	(Ereditato da Object).
	GetIsTextDirty	Determines whether the text value is consistent with stored value. (Ereditato da ScriptNameObjectBase).
	GetParameter(StringBuilder, ScriptingOptions, String, String, Int32%)	(Ereditato da SqlSmoObject).
	GetParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean)	(Ereditato da SqlSmoObject).
	GetPropValue	(Ereditato da SqlSmoObject).
	GetPropValueOptional	(Ereditato da SqlSmoObject).
	GetPropValueOptionalAllowNull	(Ereditato da SqlSmoObject).
	GetRealValue	(Ereditato da SqlSmoObject).
	GetScriptIncludeExists	(Ereditato da ScriptNameObjectBase).
	GetScriptingOptionsForCreate	(Ereditato da SqlSmoObject).
	GetServerName	Gets the name of the instance of SQL Server with which the object is associated. (Ereditato da SqlSmoObject).
	GetServerObject	(Ereditato da SqlSmoObject).
	GetSqlServerVersionName	Gets the version name of the instance of SQL Server with which the object is associated. (Ereditato da SqlSmoObject).
	GetStringParameter(StringBuilder, ScriptingOptions, String, String, Int32%)	(Ereditato da SqlSmoObject).
	GetStringParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean)	(Ereditato da SqlSmoObject).
	GetTextBody() () () ()	Returns the text body. (Ereditato da ScriptNameObjectBase).
	GetTextBody(Boolean)	Returns the text body. (Ereditato da ScriptNameObjectBase).
	GetTextForScript(ScriptingOptions, Boolean, array<String> [] () [] [])	Gets the text for scripting. (Ereditato da ScriptNameObjectBase).
	GetTextForScript(ScriptingOptions, Boolean, array<String> [] () [] [], Boolean)	(Ereditato da ScriptNameObjectBase).
	GetTextHeader	Returns the text header. (Ereditato da ScriptNameObjectBase).
	GetTextMode	Determines whether the script name is using text mode. (Ereditato da ScriptNameObjectBase).
	GetTextProperty(String)	(Ereditato da ScriptNameObjectBase).
	GetTextProperty(String, ScriptingOptions)	(Ereditato da ScriptNameObjectBase).
	GetTimeSpanParameterAsInt	(Ereditato da SqlSmoObject).
	GetType	(Ereditato da Object).
	GetUrnRecursive(StringBuilder)	(Ereditato da SqlSmoObject).
	GetUrnRecursive(StringBuilder, UrnIdOption)	(Ereditato da SqlSmoObject).
	ImplInitialize	(Ereditato da SqlSmoObject).
	Initialize() () () ()	Initializes the object and forces the properties be loaded. (Ereditato da SqlSmoObject).
	Initialize(Boolean)	Initializes the object and forces the properties be loaded. (Ereditato da SqlSmoObject).
	IsObjectDirty	Determines whether the referenced object is consistent with the stored object. (Ereditato da ScriptNameObjectBase).
	IsObjectInitialized	Verifies whether the object has been initialized. (Ereditato da SqlSmoObject).
	IsObjectInSpace	Verifies whether the object is isolated or connected to the instance of SQL Server. (Ereditato da SqlSmoObject).
	IsVersion80SP3	(Ereditato da SqlSmoObject).
	MarkDropped	(Ereditato da SqlSmoObject).
	MarkForDrop	Marks the column to be dropped when the Alter method is run on the column's parent Table object.
	MarkForDropImpl	(Ereditato da SqlSmoObject).
	MemberwiseClone	(Ereditato da Object).
	PostAlter	(Ereditato da SqlSmoObject).
	PostCreate	(Ereditato da SqlSmoObject).
	PostDrop	(Ereditato da SqlSmoObject).
	Refresh	Refreshes the Column object properties. (Esegue l'override di ScriptNameObjectBase. . :: . .Refresh() () () ().)
	Rename	Renames the column.
	RenameImpl	This method supports the SMO infrastructure and is not intended to be used directly from your code. (Ereditato da NamedSmoObject).
	RenameImplWorker	This method supports the SMO infrastructure and is not intended to be used directly from your code. (Ereditato da NamedSmoObject).
	ScriptAlter	(Ereditato da SqlSmoObject).
	ScriptAnsiQI	(Ereditato da ScriptNameObjectBase).
	ScriptChangeOwner	This method supports the SMO infrastructure and is not intended to be used directly from your code. (Ereditato da NamedSmoObject).
	ScriptCreate	(Ereditato da SqlSmoObject).
	ScriptDdl	(Ereditato da SqlSmoObject).
	ScriptDrop	(Ereditato da SqlSmoObject).
	ScriptImpl() () () ()	(Ereditato da SqlSmoObject).
	ScriptImpl(ScriptingOptions)	(Ereditato da SqlSmoObject).
	ScriptImplWorker	(Ereditato da SqlSmoObject).
	ScriptInformativeHeaders	(Ereditato da ScriptNameObjectBase).
	ScriptRename	This method supports the SMO infrastructure and is not intended to be used directly from your code. (Ereditato da NamedSmoObject).
	SetCollectionTextMode	Sets the collection text mode. (Ereditato da ScriptNameObjectBase).
	SetParentImpl	(Ereditato da SqlSmoObject).
	SetTextBody	Specifies the text body. (Ereditato da ScriptNameObjectBase).
	SetTextHeader	Specifies the text header. (Ereditato da ScriptNameObjectBase).
	SetTextMode	Specifies the text mode. (Ereditato da ScriptNameObjectBase).
	SwitchTextMode	Switches the text mode. (Ereditato da ScriptNameObjectBase).
	ThrowIfTextIsDirtyForAlter	(Ereditato da ScriptNameObjectBase).
	ToString	Returns a String that represents the referenced object. (Ereditato da SqlSmoObject).
	TouchImpl	(Ereditato da SqlSmoObject).
	UnbindDefault	Unbinds the currently bound default from the column.
	UnbindDefaultImpl	(Ereditato da SqlSmoObject).
	UnbindRule	Unbinds the currently bound rule from the column.
	UnbindRuleImpl	(Ereditato da SqlSmoObject).
	UpdateStatistics() () () ()	Updates Statistic objects that monitor this column.
	UpdateStatistics(StatisticsScanType)	Updates Statistic objects that monitor this column.
	UpdateStatistics(StatisticsScanType, Int32)	Updates Statistic objects that monitor this column using a sampled scan.
	UpdateStatistics(StatisticsScanType, Int32, Boolean)	Updates Statistic objects that monitor this column using a sampled scan.
	Validate	(Ereditato da SmoObjectBase).

In alto

Campi

	Nome	Descrizione
	m_ExtendedProperties	(Ereditato da SqlSmoObject).

In alto

Proprietà

	Nome	Descrizione
	AnsiPaddingStatus	Gets or sets a Boolean property value that specifies whether the ANSI_PADDING_ENABLED column option is active.
	Collation	Gets or sets the default collation that is used by the column.
	Computed	Gets the Boolean property value that specifies whether the column is the product of computed expression
	ComputedText	Gets or sets the Transact-SQL expression that is used to generate the value of a computed column
	DataType	Gets or sets the data type that is assigned to the column.
	Default	Gets the default bound to the column.
	DefaultConstraint	Gets or sets a default value for the column.
	DefaultSchema	Gets or sets the default schema that is bound to the column.
	ExecuteForScalar	Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option. (Ereditato da SqlSmoObject).
	ExtendedProperties	Represents a collection of ExtendedProperty objects. Each ExtendedProperty object represents an extended property for the Column object.
	ID	Gets the column ID that uniquely identifies the column.
	Identity	Gets or sets the Boolean property value that specifies whether the column is an identity column.
	IdentityIncrement	Gets or sets the identity increment for an identity column.
	IdentitySeed	Gets or sets the identity seed for an identity column.
	InPrimaryKey	Gets the Boolean property value that specifies whether the column is included in the definition of a primary key or unique key constraint.
	IsColumnSet	Gets or sets the Boolean property value that specifies whether the column has been set.
	IsDeterministic	Gets or sets the Boolean property value that specifies whether the value of a computed column can change in subsequent invocations.
	IsFileStream	Gets a boolean value that represents the FILESTREAM attribute of the column.
	IsForeignKey	Gets the Boolean property value that specifies whether the column is a foreign key.
	IsFullTextIndexed	Gets the Boolean property value that specifies whether the column participates in a full-text index.
	IsPersisted	Gets the Boolean property value that specifies whether the computed value of the Column object is saved with the data, thus avoiding a computation each time the column is accessed.
	IsPrecise	Gets or sets the Boolean property value that specifies whether a computed column is a precise value.
	IsSparse	Gets or sets the Boolean property value that specifies whether the column value is sparse.
	IsTouched	Gets the Boolean property value that specifies whether the object properties have been updated but not yet persisted on the server. (Ereditato da SqlSmoObject).
	Name	Gets or sets the name of the object. (Ereditato da NamedSmoObject).
	NotForReplication	Gets the Boolean property value that specifies whether the column is participating in replication.
	Nullable	Gets or sets the Boolean property value that specifies whether the column can accept null values.
	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. (Ereditato da SqlSmoObject).
	Parent	Gets the SqlSmoObject object that is the parent of the Column object.
	Properties	Gets a collection of Property objects that represent the object properties. (Ereditato da SqlSmoObject).
	RowGuidCol	Gets or sets the Boolean property value that specifies whether the column is automatically updated with a unique GUID value.
	Rule	Gets or sets the rule that is bound to the column.
	RuleSchema	Gets or sets the rule schema that is bound to the column.
	ScalarResult	Gets the scalar result for the referenced object. (Ereditato da SqlSmoObject).
	State	Gets the state of the referenced object. (Ereditato da SmoObjectBase).
	Urn	Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (Ereditato da SqlSmoObject).
	UserData	Gets or sets user-defined data associated with the referenced object. (Ereditato da SmoObjectBase).

In alto

Eventi

	Nome	Descrizione
	PropertyChanged	(Ereditato da SqlSmoObject).
	PropertyMetadataChanged	(Ereditato da SqlSmoObject).

In alto

Implementazioni esplicite dell'interfaccia

	Nome	Descrizione
	IAlienObjectDiscover	(Ereditato da SqlSmoObject).
	IAlienObjectGetParent	(Ereditato da SqlSmoObject).
	IAlienObjectGetProperty	(Ereditato da SqlSmoObject).
	ISfcPropertyProviderGetPropertySet	(Ereditato da SqlSmoObject).
	IAlienObjectGetUrn	(Ereditato da SqlSmoObject).
	IAlienObjectResolve	(Ereditato da SqlSmoObject).
	IAlienObjectSetProperty	(Ereditato da SqlSmoObject).

In alto

Vedere anche

Riferimento

Column Classe

Spazio dei nomi Microsoft.SqlServer.Management.Smo