| AbstractTableManager Methods |
The AbstractTableManager type exposes the following members.
Methods| Name | Description | |
|---|---|---|
 | AddTableColumn |
Add column to specified table.
|
| AlterProcedure |
Alters specified procedure in database
|
| AlterTableColumn |
Rename, retype or allow/not allow NULL values in column
|
| AlterTableColumnWithDefaultValue |
Alter table column with default value.
|
| AlterView |
Creates specified view in database
|
| ColumnExistsInView |
Checks if column name is unique in given view.
|
| CreateColumnIndexes |
Creates the table indexes.
|
| CreateProcedure |
Creates specified procedure in database
|
| CreateTable(String, String) |
Creates specified table in database.
|
| CreateTable(String, String, Boolean) |
Creates specified table in database.
|
| CreateView |
Creates specified view in database
|
| DeleteDataFromTable |
Deletes data from specified table.
|
| DeleteObject |
Removes view or stored procedure from database.
|
| DropColumnIndexes |
Drops the column indexes, returns the DataSet of indexes.
|
| DropDefaultConstraint |
Drops the default constraint.
|
| DropTable |
Drop specified table from database.
|
| DropTableColumn |
Remove column from specified table.
|
| DropView |
Drop specified view from database. Returns the schema of the dropped view
|
 | EnsureDefaultValue |
Add apostrophes around the column default value string according to column type.
|
| ExecuteQuery |
Executes query and returns the results in a DataSet.
|
| ExecuteScalar |
Executes query and returns the results in a DataSet.
|
| GetCode |
Returns SQL code of specified view or stored procedure.
|
| GetColumnIndexes |
Returns the DataSet of column indexes.
|
| GetColumnInformation |
Returns DataSet with specified table column information retrieved from database information schema. Returns columns ColumnName, DataType, DataSize, DataPrecision, Nullable, DefaultValue
|
| GetConnection |
Gets the connection for the table management
|
 | GetConstraintName |
Returns constraint's name truncated to 128 chars (128 chars is limit of database column name).
|
| GetDatabaseInfo |
Gets size related information about the database.
|
| GetDatabaseSize |
Gets database size (including log size) or N/A string if the size cannot be retrieved
|
| GetDatabaseVersion |
Gets the database version
|
| GetIndexes |
Returns DataSet with indexes of the given object. Returns columns IndexName, DropScript, CreateScript
|
| GetList |
Returns list of views or stored procedures.
|
| GetPKConstraintName |
Returns the name of the primary key constraint.
|
| GetPrimaryKeyColumns |
Returns list of column names which represent primary keys of the specified database table.
Returns empty list if primary keys are not found.
|
| GetTableDependencies |
Gets list of object names which have foreign key constraint dependency.
|
| GetTablePKName |
Returns name of the primary key. If more columns in PK, names are separated by semicolon ";".
|
| GetTables |
Gets the tables in the current database
|
| GetValueString |
Returns the value string using the database culture. Does not include apostrophes for types that need them
|
| GetXmlSchema |
Returns XML schema for specified table.
|
| ChangeDBObjectOwner |
Changes database object owner.
|
| RecreatePKConstraint |
Drops the current primary key constraint and creates new from given columns.
|
| RefreshView |
Refreshes specified view in database.
|
| RenameColumn |
Changes name of the column.
|
| RenameTable |
Changes name of the table with original name according to the new name.
|
| StoredProcedureExists |
Determines whether specified stored procedure exists or not.
|
| TableExists |
Determines whether specified DB table exists or not.
|
| ViewExists(String) |
Determines whether specified DB view exists or not.
|
| ViewExists(String, String) |
Determines whether specified DB view exists or not.
|
Extension Methods| Name | Description | |
|---|---|---|
 | AsValue |
Converts object to a query value which can be used as a query parameter
(Defined by QueryExtensions.) |
| GetAPIString |
Gets the string by the specified resource key
(Defined by CoreExtensions.) |
| GetString |
Gets the string by the specified resource key
(Defined by CoreExtensions.) |
| ToBoolean |
Returns the boolean representation of an object or default value if not.
(Defined by CoreExtensions.) |
| ToDateTime |
Returns the DateTime representation of an object or default value if not.
(Defined by CoreExtensions.) |
| ToDouble |
Returns the double representation of an object or default value if not.
(Defined by CoreExtensions.) |
| ToGuid |
Returns the Guid representation of an object or default value if not.
(Defined by CoreExtensions.) |
| ToInteger |
Returns the integer representation of an object or default value if not.
(Defined by CoreExtensions.) |
| ToString |
Returns the string representation of an object or default value if not.
(Defined by CoreExtensions.) |
See Also