TableManager Members

Kentico 8.1 API Reference

The TableManager type exposes the following members.

Constructors

	Name	Description
	TableManager	Constructor

Methods

	Name	Description
	AddTableColumn	Add column to specified table.
	AlterTableColumn	Rename, retype or allow/not allow NULL values in column
	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.
	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 for given data class.
	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.
	Equals	Determines whether the specified Object is equal to the current Object. (Inherited from Object.)
	Finalize	Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.)
	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
	GetHashCode	Serves as a hash function for a particular type. (Inherited from Object.)
	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.
	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
	GetType	Gets the Type of the current instance. (Inherited from Object.)
	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.
	MemberwiseClone	Creates a shallow copy of the current Object. (Inherited from Object.)
	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.
	ToString	Returns a string that represents the current object. (Inherited from Object.)
	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.

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.)

Fields

	Name	Description
	USE_INDEXED_VIEWS	If true, the indexed views are used and generated within the system

Properties

	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.