TableManager Class

Ensures management of database table and table column.

Inheritance Hierarchy

System.Object
  CMS.DataEngine.AbstractTableManager
    CMS.DataProviderSQL.TableManager

Namespace: CMS.DataProviderSQL
Assembly: CMS.DataProviderSQL (in CMS.DataProviderSQL.dll) Version: 8.2.23

Syntax

public class TableManager : AbstractTableManager

The TableManager type exposes the following members.

Constructors

	Name	Description
Public method	TableManager

Methods

	Name	Description
Public method	AddTableColumn	Add column to specified table. (Inherited from AbstractTableManager.)
Public method	AlterProcedure	Alters specified procedure in database (Inherited from AbstractTableManager.)
Public method	AlterTableColumn	Rename, retype or allow/not allow NULL values in column (Inherited from AbstractTableManager.)
Public method	AlterTableColumnWithDefaultValue	Alter table column with default value. (Inherited from AbstractTableManager.)
Public method	AlterView	Creates specified view in database (Inherited from AbstractTableManager.)
Public method	ColumnExistsInView	Checks if column name is unique in given view. (Inherited from AbstractTableManager.)
Public method	CreateColumnIndexes	Creates the table indexes. (Inherited from AbstractTableManager.)
Public method	CreateProcedure	Creates specified procedure in database (Inherited from AbstractTableManager.)
Public method	CreateTable(String, String)	Creates specified table in database. (Inherited from AbstractTableManager.)
Public method	CreateTable(String, String, Boolean)	Creates specified table in database. (Inherited from AbstractTableManager.)
Public method	CreateView	Creates specified view in database (Inherited from AbstractTableManager.)
Public method	DeleteDataFromTable	Deletes data from specified table. (Inherited from AbstractTableManager.)
Public method	DeleteObject	Removes view or stored procedure from database. (Inherited from AbstractTableManager.)
Public method	DropColumnIndexes	Drops the column indexes, returns the DataSet of indexes. (Inherited from AbstractTableManager.)
Public method	DropDefaultConstraint	Drops the default constraint. (Inherited from AbstractTableManager.)
Public method	DropTable	Drop specified table from database. (Inherited from AbstractTableManager.)
Public method	DropTableColumn	Remove column from specified table. (Inherited from AbstractTableManager.)
Public method	DropView	Drop specified view from database. Returns the schema of the dropped view (Inherited from AbstractTableManager.)
Protected method	EnsureDefaultValue	Add apostrophes around the column default value string according to column type. (Inherited from AbstractTableManager.)
Public method	ExecuteQuery	Executes query and returns the results in a DataSet. (Inherited from AbstractTableManager.)
Public method	ExecuteScalar	Executes query and returns the results in a DataSet. (Inherited from AbstractTableManager.)
Public method	GetCode	Returns SQL code of specified view or stored procedure. (Inherited from AbstractTableManager.)
Public method	GetColumnIndexes	Returns the DataSet of column indexes. (Inherited from AbstractTableManager.)
Public method	GetColumnInformation	Returns DataSet with specified table column information retrieved from database information schema. Returns columns ColumnName, DataType, DataSize, DataPrecision, Nullable, DefaultValue (Inherited from AbstractTableManager.)
Protected method	GetConnection	Gets the connection for the table management (Inherited from AbstractTableManager.)
Protected method	GetDatabaseInfo	Gets size related information about the database. (Inherited from AbstractTableManager.)
Protected method	GetDatabaseSize	Gets database size (including log size) or N/A string if the size cannot be retrieved (Inherited from AbstractTableManager.)
Protected method	GetDatabaseVersion	Gets the database version (Inherited from AbstractTableManager.)
Public method	GetIndexes	Returns DataSet with indexes of the given object. Returns columns IndexName, DropScript, CreateScript (Inherited from AbstractTableManager.)
Public method	GetList	Returns list of views or stored procedures. (Inherited from AbstractTableManager.)
Public method	GetPKConstraintName	Returns the name of the primary key constraint. (Inherited from AbstractTableManager.)
Public method	GetPrimaryKeyColumns	Returns list of column names which represent primary keys of the specified database table. Returns empty list if primary keys are not found. (Inherited from AbstractTableManager.)
Public method	GetTableDependencies	Gets list of object names which have foreign key constraint dependency. (Inherited from AbstractTableManager.)
Public method	GetTablePKName	Returns name of the primary key. If more columns in PK, names are separated by semicolon ";". (Inherited from AbstractTableManager.)
Public method	GetTables	Gets the tables in the current database (Inherited from AbstractTableManager.)
Public method	GetValueString	Returns the value string using the database culture. Does not include apostrophes for types that need them (Inherited from AbstractTableManager.)
Public method	GetXmlSchema	Returns XML schema for specified table. (Inherited from AbstractTableManager.)
Public method	ChangeDBObjectOwner	Changes database object owner. (Inherited from AbstractTableManager.)
Public method	RecreatePKConstraint	Drops the current primary key constraint and creates new from given columns. (Inherited from AbstractTableManager.)
Public method	RefreshView	Refreshes specified view in database. (Inherited from AbstractTableManager.)
Public method	RenameColumn	Changes name of the column. (Inherited from AbstractTableManager.)
Public method	RenameTable	Changes name of the table with original name according to the new name. (Inherited from AbstractTableManager.)
Public method	StoredProcedureExists	Determines whether specified stored procedure exists or not. (Inherited from AbstractTableManager.)
Public method	TableExists	Determines whether specified DB table exists or not. (Inherited from AbstractTableManager.)
Public method	ViewExists(String)	Determines whether specified DB view exists or not. (Inherited from AbstractTableManager.)
Public method	ViewExists(String, String)	Determines whether specified DB view exists or not. (Inherited from AbstractTableManager.)

Extension Methods

	Name	Description
Public Extension Method	AsValue	Converts object to a query value which can be used as a query parameter (Defined by QueryExtensions.)
Public Extension Method	GetAPIString	Gets the string by the specified resource key (Defined by CoreExtensions.)
Public Extension Method	GetString	Gets the string by the specified resource key (Defined by CoreExtensions.)
Public Extension Method	ToBoolean	Returns the boolean representation of an object or default value if not. (Defined by CoreExtensions.)
Public Extension Method	ToDateTime	Returns the DateTime representation of an object or default value if not. (Defined by CoreExtensions.)
Public Extension Method	ToDouble	Returns the double representation of an object or default value if not. (Defined by CoreExtensions.)
Public Extension Method	ToGuid	Returns the Guid representation of an object or default value if not. (Defined by CoreExtensions.)
Public Extension Method	ToInteger	Returns the integer representation of an object or default value if not. (Defined by CoreExtensions.)
Public Extension Method	ToString	Returns the string representation of an object or default value if not. (Defined by CoreExtensions.)

Fields

	Name	Description
Protected field	mDatabaseCulture	Database culture setting from the web.config. (Inherited from AbstractTableManager.)

Properties

	Name	Description
Public property	ConnectionString	Connection string to use for table management (Inherited from AbstractTableManager.)
Public property	DatabaseCulture	Database culture setting from the web.config. (Inherited from AbstractTableManager.)
Public property	DatabaseName	Database name. (Inherited from AbstractTableManager.)
Public property	DatabaseServerName	Name of database server. (Inherited from AbstractTableManager.)
Public property	DatabaseServerVersion	Version of database server. (Inherited from AbstractTableManager.)
Public property	DatabaseSize	Database size(including log size) in MB. (Inherited from AbstractTableManager.)
Public property	DatabaseVersion	Database version (Inherited from AbstractTableManager.)
Public property	DisableDebug	If true, the debug is disabled in this table manager (Inherited from AbstractTableManager.)