Свойство | Type | Description | |
---|---|---|---|
SystemSchemas | List |
Méthode | Description | |
---|---|---|
AddDefaultConstraint ( ObjectName tableName, string columnName, string definition ) : |
||
AlterSchema ( ObjectName oldName, SchemaName schemaName ) : |
||
AlterTableAddColumn ( ITable table, IColumn column ) : |
||
AlterTableAddConstraintForeignKey ( ITable table, string fieldName, ITable foreignTable ) : |
||
AlterTableAddDefaultConstraint ( ObjectName tableName, string column, string constraintName, string definition ) : |
||
AlterTableAlterColumn ( ITable table, IColumn column ) : |
||
AlterTableDropColumn ( ITable table, string columnName ) : |
||
AlterTableDropConstraint ( ObjectName tableName, ObjectName constraintName ) : |
||
AlterTableForeignKeys ( ITable t ) : |
||
CreateAllIndices ( ITable t ) : |
||
CreateColumn ( IColumn c ) : string | ||
CreateColumn ( string name, SqlDbType type, string udtTypeName, int size, int scale, bool nullable, bool identity, string @default ) : string | ||
CreateIndex ( |
||
CreateSchema ( SchemaName schemaName ) : |
||
CreateTableSql ( ITable t ) : |
||
DisableForeignKey ( ObjectName tableName, string foreignKey ) : |
||
DisableIndex ( ObjectName tableName, string indexName ) : |
||
DropDefaultConstraint ( ObjectName tableName, string columnName ) : |
||
DropIndex ( ObjectName tableName, |
||
DropIndex ( ObjectName objectName, string indexName ) : |
||
DropIndex ( |
||
DropPrimaryKeyConstraint ( ObjectName tableName ) : |
||
DropSchema ( SchemaName schemaName ) : |
||
DropTable ( ObjectName tableName ) : |
||
DropView ( ObjectName viewName ) : |
||
EnableForeignKey ( ObjectName tableName, string foreignKey ) : |
||
EnableIndex ( ObjectName tableName, string indexName ) : |
||
ForeignKeyName ( string table, string fieldName ) : string | ||
GetSizeScale ( int size, int scale ) : string | ||
IsDate ( SqlDbType sqlDbType ) : bool | ||
IsNumber ( SqlDbType sqlDbType ) : bool | ||
IsString ( SqlDbType sqlDbType ) : bool | ||
MakeSnapshotIsolationDefault ( string databaseName, bool value ) : |
||
MoveRows ( ObjectName oldTable, ObjectName newTable, IEnumerable |
||
ReCreateFreeIndex ( ITable table, |
||
RenameColumn ( ITable table, string oldName, string newName ) : |
||
RenameForeignKey ( ObjectName foreignKeyName, string newName ) : |
||
RenameIndex ( ITable table, string oldName, string newName ) : |
||
RenameOrMove ( |
||
RenameTable ( ObjectName oldName, string newName ) : |
||
SP_RENAME ( DatabaseName database, string oldName, string newName, string objectType ) : |
||
SelectRowCount ( ) : |
||
SetIdentityInsert ( ObjectName tableName, bool value ) : |
||
SetMultiUser ( string databaseName ) : |
||
SetSingleUser ( string databaseName ) : |
||
SetSnapshotIsolation ( string databaseName, bool value ) : |
Méthode | Description | |
---|---|---|
DropStatistics ( string tn, List |
||
DropViewIndex ( ObjectName viewName, string index ) : |
||
Quote ( SqlDbType type, string @default ) : string | ||
UpdateTrim ( ITable tab, IColumn tabCol ) : |
public static AddDefaultConstraint ( ObjectName tableName, string columnName, string definition ) : |
||
tableName | ObjectName | |
columnName | string | |
definition | string | |
Résultat |
public static AlterSchema ( ObjectName oldName, SchemaName schemaName ) : |
||
oldName | ObjectName | |
schemaName | SchemaName | |
Résultat |
public static AlterTableAddColumn ( ITable table, IColumn column ) : |
||
table | ITable | |
column | IColumn | |
Résultat |
public static AlterTableAddConstraintForeignKey ( ITable table, string fieldName, ITable foreignTable ) : |
||
table | ITable | |
fieldName | string | |
foreignTable | ITable | |
Résultat |
public static AlterTableAddDefaultConstraint ( ObjectName tableName, string column, string constraintName, string definition ) : |
||
tableName | ObjectName | |
column | string | |
constraintName | string | |
definition | string | |
Résultat |
public static AlterTableAlterColumn ( ITable table, IColumn column ) : |
||
table | ITable | |
column | IColumn | |
Résultat |
public static AlterTableDropColumn ( ITable table, string columnName ) : |
||
table | ITable | |
columnName | string | |
Résultat |
public static AlterTableDropConstraint ( ObjectName tableName, ObjectName constraintName ) : |
||
tableName | ObjectName | |
constraintName | ObjectName | |
Résultat |
public static AlterTableForeignKeys ( ITable t ) : |
||
t | ITable | |
Résultat |
public static CreateAllIndices ( ITable t ) : |
||
t | ITable | |
Résultat |
public static CreateColumn ( IColumn c ) : string | ||
c | IColumn | |
Résultat | string |
public static CreateColumn ( string name, SqlDbType type, string udtTypeName, int size, int scale, bool nullable, bool identity, string @default ) : string | ||
name | string | |
type | SqlDbType | |
udtTypeName | string | |
size | int | |
scale | int | |
nullable | bool | |
identity | bool | |
@default | string | |
Résultat | string |
public static CreateIndex ( |
||
index | ||
Résultat |
public static CreateSchema ( SchemaName schemaName ) : |
||
schemaName | SchemaName | |
Résultat |
public static CreateTableSql ( ITable t ) : |
||
t | ITable | |
Résultat |
public static DisableForeignKey ( ObjectName tableName, string foreignKey ) : |
||
tableName | ObjectName | |
foreignKey | string | |
Résultat |
public static DisableIndex ( ObjectName tableName, string indexName ) : |
||
tableName | ObjectName | |
indexName | string | |
Résultat |
public static DropDefaultConstraint ( ObjectName tableName, string columnName ) : |
||
tableName | ObjectName | |
columnName | string | |
Résultat |
public static DropIndex ( ObjectName tableName, |
||
tableName | ObjectName | |
index | ||
Résultat |
public static DropIndex ( ObjectName objectName, string indexName ) : |
||
objectName | ObjectName | |
indexName | string | |
Résultat |
public static DropIndex ( |
||
ix | ||
Résultat |
public static DropPrimaryKeyConstraint ( ObjectName tableName ) : |
||
tableName | ObjectName | |
Résultat |
public static DropSchema ( SchemaName schemaName ) : |
||
schemaName | SchemaName | |
Résultat |
public static DropTable ( ObjectName tableName ) : |
||
tableName | ObjectName | |
Résultat |
public static DropView ( ObjectName viewName ) : |
||
viewName | ObjectName | |
Résultat |
public static EnableForeignKey ( ObjectName tableName, string foreignKey ) : |
||
tableName | ObjectName | |
foreignKey | string | |
Résultat |
public static EnableIndex ( ObjectName tableName, string indexName ) : |
||
tableName | ObjectName | |
indexName | string | |
Résultat |
public static ForeignKeyName ( string table, string fieldName ) : string | ||
table | string | |
fieldName | string | |
Résultat | string |
public static GetSizeScale ( int size, int scale ) : string | ||
size | int | |
scale | int | |
Résultat | string |
public static IsDate ( SqlDbType sqlDbType ) : bool | ||
sqlDbType | SqlDbType | |
Résultat | bool |
public static IsNumber ( SqlDbType sqlDbType ) : bool | ||
sqlDbType | SqlDbType | |
Résultat | bool |
public static IsString ( SqlDbType sqlDbType ) : bool | ||
sqlDbType | SqlDbType | |
Résultat | bool |
public static MakeSnapshotIsolationDefault ( string databaseName, bool value ) : |
||
databaseName | string | |
value | bool | |
Résultat |
public static MoveRows ( ObjectName oldTable, ObjectName newTable, IEnumerable |
||
oldTable | ObjectName | |
newTable | ObjectName | |
columnNames | IEnumerable |
|
Résultat |
public static ReCreateFreeIndex ( ITable table, |
||
table | ITable | |
index | ||
oldTable | string | |
tableReplacements | string>.Dictionary | |
Résultat |
public static RenameColumn ( ITable table, string oldName, string newName ) : |
||
table | ITable | |
oldName | string | |
newName | string | |
Résultat |
public static RenameForeignKey ( ObjectName foreignKeyName, string newName ) : |
||
foreignKeyName | ObjectName | |
newName | string | |
Résultat |
public static RenameIndex ( ITable table, string oldName, string newName ) : |
||
table | ITable | |
oldName | string | |
newName | string | |
Résultat |
public static RenameOrMove ( |
||
oldTable | ||
newTable | ITable | |
Résultat |
public static RenameTable ( ObjectName oldName, string newName ) : |
||
oldName | ObjectName | |
newName | string | |
Résultat |
public static SP_RENAME ( DatabaseName database, string oldName, string newName, string objectType ) : |
||
database | DatabaseName | |
oldName | string | |
newName | string | |
objectType | string | |
Résultat |
public static SelectRowCount ( ) : |
||
Résultat |
public static SetIdentityInsert ( ObjectName tableName, bool value ) : |
||
tableName | ObjectName | |
value | bool | |
Résultat |
public static SetMultiUser ( string databaseName ) : |
||
databaseName | string | |
Résultat |
public static SetSingleUser ( string databaseName ) : |
||
databaseName | string | |
Résultat |
public static SetSnapshotIsolation ( string databaseName, bool value ) : |
||
databaseName | string | |
value | bool | |
Résultat |