Membri ForeignKey
The ForeignKey object represents a SQL Server foreign key.
Il tipo ForeignKey espone i membri seguenti.
Costruttori
Nome | Descrizione | |
---|---|---|
ForeignKey() () () () | Initializes a new instance of the ForeignKey class. | |
ForeignKey(Table, String) | Initializes a new instance of the ForeignKey class on the specified table with the specified name. |
In alto
Metodi
Nome | Descrizione | |
---|---|---|
AddDatabaseContext | (Ereditato da SqlSmoObject). | |
Alter | Updates any ForeignKey object property changes on 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). | |
BindDefaultImpl | (Ereditato da SqlSmoObject). | |
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 foreign key on the instance of SQL Server as defined by the ForeignKey object. | |
CreateImpl | (Ereditato da SqlSmoObject). | |
CreateImplFinish | (Ereditato da SqlSmoObject). | |
CreateImplInit | (Ereditato da SqlSmoObject). | |
Discover | (Ereditato da SqlSmoObject). | |
Drop | Drops the foreign key. | |
DropImpl | (Ereditato da SqlSmoObject). | |
DropImplWorker | (Ereditato da SqlSmoObject). | |
EnumScriptImpl | (Ereditato da SqlSmoObject). | |
EnumScriptImplWorker | (Ereditato da SqlSmoObject). | |
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 foreign key to be dropped the next time its parent Table object is altered by the Alter method. | |
MarkForDropImpl | (Ereditato da SqlSmoObject). | |
MemberwiseClone | (Ereditato da Object). | |
PostAlter | (Ereditato da SqlSmoObject). | |
PostCreate | (Ereditato da SqlSmoObject). | |
PostDrop | (Ereditato da SqlSmoObject). | |
Refresh | Refreshes the script name. (Ereditato da ScriptNameObjectBase). | |
Rename | Renames the foreign key to the specified new name. | |
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). | |
Script() () () () | Generates a Transact-SQL script that can be used to re-create the foreign key. | |
Script(ScriptingOptions) | Generates a Transact-SQL script that can be used to re-create the foreign key as specified by the script options. | |
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). | |
UnbindDefaultImpl | (Ereditato da SqlSmoObject). | |
UnbindRuleImpl | (Ereditato da SqlSmoObject). | |
Validate | (Ereditato da SmoObjectBase). |
In alto
Proprietà
Nome | Descrizione | |
---|---|---|
Columns | Represents a collection of Column objects. Each Column object represents a column included in the foreign key. | |
CreateDate | Gets the date and time when the foreign key was created. | |
DateLastModified | Gets the date and time when the foreign key was last modified. | |
DeleteAction | Gets or sets the action taken when the row that is referenced by the foreign key is deleted. | |
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 on the ForeignKey object. | |
ID | Gets the ID value that uniquely identifies the foreign key. | |
IsChecked | Gets or sets the Boolean property value that specifies whether the foreign key constraint was enabled without checking existing rows. | |
IsEnabled | Gets or sets the Boolean property value that specifies whether the foreign key is enabled. | |
IsSystemNamed | Gets the Boolean property value that specifies whether the foreign key is named by the system or by the user. | |
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 foreign key is available for replication. | |
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 or sets the Table object that is the parent of the ForeignKey object. | |
Properties | Gets a collection of Property objects that represent the object properties. (Ereditato da SqlSmoObject). | |
ReferencedKey | Gets the primary key referenced by the foreign key. | |
ReferencedTable | Gets or sets the table that contains the primary key referenced by the foreign key. | |
ReferencedTableSchema | Gets or sets the table schema that contains the primary key referenced by the foreign key. | |
ScalarResult | Gets the scalar result for the referenced object. (Ereditato da SqlSmoObject). | |
ScriptReferencedTable | Gets or sets the Boolean value that specifies whether to script the table referenced by the foreign key. | |
ScriptReferencedTableSchema | Gets or sets the Boolean value that specifies whether to script the schema of the table referenced by the foreign key. | |
State | Gets the state of the referenced object. (Ereditato da SmoObjectBase). | |
UpdateAction | Gets or sets the Boolean property value that specifies whether the foreign key supports cascading updates. | |
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