TableManager Class |
Namespace: CMS.DataEngine
public class TableManager
The TableManager type exposes the following members.
Name | Description | |
---|---|---|
TableManager |
Constructor
|
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
| |
AlterView |
Alters specified view in database
| |
ColumnExistsInView |
Checks if column name is unique in given view.
| |
CopyTableBySchema |
Copies given table as a new one from given table cheme (ensures unique table name for the new table).
| |
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. Allows specify if identity will be set on primary key column.
| |
CreateTableByDefinition(String, String) |
Creates a new database table based on the provided Schema.
| |
CreateTableByDefinition(String, String, String) |
Creates a new database table based on the provided Schema.
| |
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.
| |
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
| |
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 PK 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
| |
GetUniqueTableName |
Returns unique table name (automatically generated table name that not yet exist in the database).
| |
GetValueString |
Returns the float string using the database culture.
| |
GetXmlSchema |
Returns XML schema for specified table.
| |
ChangeDBObjectOwner |
Changes database object owner.
| |
IsGeneratedSystemView |
Returns true if the given view is generated view with dynamic code.
| |
RecreatePKConstraint |
Drops the current PK constraint and creates new from given columns.
| |
RefreshCustomViews |
Refreshes all database views which should contain all columns of the specified system table (cms_user, cms_usersettings, com_sku, newsletter_subscriber, community_group).
You need to call this method after the column of that system table is added or removed.
| |
RefreshDocumentViews |
Regenerates views [View_CMS_Tree_Joined], [View_CMS_Tree_Joined_Versions], [View_CMS_Tree_Joined_Attachments], [View_CMS_Tree_Joined_Versions_Attachments] and default views for all document types.
| |
RefreshView |
Refreshes specified view in database.
| |
RenameTable |
Changes name of the table with original name according to the new name.
| |
SelectFieldNode |
Selects single field node with the specified attribute value.
| |
StoredProcedureExists |
Determines whether specified stored procedure exists or not.
| |
TableExists |
Determines whether specified DB table exists or not.
| |
UpdateTableByDefinition |
Updates the structure of given table with new schema. It adds, modifies or removes the columns.
| |
ViewExists |
Determines whether specified DB view exists or not.
|
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.) |
Name | Description | |
---|---|---|
USE_INDEXED_VIEWS |
If true, the indexed views are used and generated within the system
|
Name | Description | |
---|---|---|
ConnectionString |
Current connection string for the table management
| |
DatabaseCulture |
Database culture setting from the web.config.
| |
DatabaseCultureInfo |
Database culture info obtained from DatabaseCulture property.
| |
DatabaseName |
Gets database name.
| |
DatabaseServerName |
Gets database server name.
| |
DatabaseServerVersion |
Gets database server version.
| |
DatabaseSize |
Gets database size(including log size) in MB.
| |
DisableDebug |
If true, the table manager disables debug for its queries
| |
TableManagerObject |
Table manager object
| |
UpdateSystemFields |
Determines whether system fields should be updated when updating table by schema.
|