TableManager MembersKentico 8.1 API Reference
The TableManager type exposes the following members.
Constructors

  NameDescription
Public methodTableManager
Constructor
Back to Top
Methods

  NameDescription
Public methodAddTableColumn
Add column to specified table.
Public methodAlterTableColumn
Rename, retype or allow/not allow NULL values in column
Public methodColumnExistsInView
Checks if column name is unique in given view.
Public methodCopyTableBySchema
Copies given table as a new one from given table cheme (ensures unique table name for the new table).
Public methodCreateColumnIndexes
Creates the table indexes.
Public methodCreateTable(String, String)
Creates specified table in database.
Public methodCreateTable(String, String, Boolean)
Creates specified table in database. Allows specify if identity will be set on primary key column.
Public methodCreateTableByDefinition(String, String)
Creates a new database table based on the provided Schema.
Public methodCreateTableByDefinition(String, String, String )
Creates a new database table based on the provided Schema.
Public methodCreateView
Creates specified view in database for given data class.
Public methodDeleteDataFromTable
Deletes data from specified table.
Public methodDeleteObject
Removes view or stored procedure from database.
Public methodDropColumnIndexes
Drops the column indexes, returns the DataSet of indexes.
Public methodDropDefaultConstraint
Drops the default constraint.
Public methodDropTable
Drop specified table from database.
Public methodDropTableColumn
Remove column from specified table.
Public methodDropView
Drop specified view from database.
Public methodOnlineEquals
Determines whether the specified OnlineObject is equal to the current OnlineObject.
(Inherited from OnlineObject.)
Protected methodOnlineFinalize
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from OnlineObject.)
Public methodGetCode
Returns SQL code of specified view or stored procedure.
Public methodGetColumnIndexes
Returns the DataSet of column indexes.
Public methodGetColumnInformation
Returns DataSet with specified table column information retrieved from database information schema. Returns columns ColumnName, DataType, DataSize, DataPrecision, Nullable, DefaultValue
Public methodOnlineGetHashCode
Serves as a hash function for a particular type.
(Inherited from OnlineObject.)
Public methodGetList
Returns list of views or stored procedures.
Public methodGetPKConstraintName
Returns the name of the PK constraint.
Public methodGetPrimaryKeyColumns
Returns list of column names which represent primary keys of the specified database table. Returns empty list if primary keys are not found.
Public methodGetTablePKName
Returns name of the primary key. If more columns in PK, names are separated by semicolon ";".
Public methodGetTables
Gets the tables in the current database
Public methodOnlineGetType
Gets the OnlineType of the current instance.
(Inherited from OnlineObject.)
Public methodGetUniqueTableName
Returns unique table name (automatically generated table name that not yet exist in the database).
Public methodStatic memberGetValueString
Returns the float string using the database culture.
Public methodGetXmlSchema
Returns XML schema for specified table.
Public methodChangeDBObjectOwner
Changes database object owner.
Public methodStatic memberIsGeneratedSystemView
Returns true if the given view is generated view with dynamic code.
Protected methodOnlineMemberwiseClone
Creates a shallow copy of the current OnlineObject.
(Inherited from OnlineObject.)
Public methodRecreatePKConstraint
Drops the current PK constraint and creates new from given columns.
Public methodRefreshCustomViews
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.
Public methodRefreshDocumentViews
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.
Public methodRefreshView
Refreshes specified view in database.
Public methodRenameTable
Changes name of the table with original name according to the new name.
Public methodStatic memberSelectFieldNode
Selects single field node with the specified attribute value.
Public methodStoredProcedureExists
Determines whether specified stored procedure exists or not.
Public methodTableExists
Determines whether specified DB table exists or not.
Public methodOnlineToString
Returns a string that represents the current object.
(Inherited from OnlineObject.)
Public methodUpdateTableByDefinition
Updates the structure of given table with new schema. It adds, modifies or removes the columns.
Public methodViewExists
Determines whether specified DB view exists or not.
Back to Top
Extension Methods

  NameDescription
Public Extension MethodAsValue
Converts object to a query value which can be used as a query parameter
(Defined by QueryExtensions.)
Public Extension MethodGetAPIString
Gets the string by the specified resource key
(Defined by CoreExtensions.)
Public Extension MethodGetString
Gets the string by the specified resource key
(Defined by CoreExtensions.)
Public Extension MethodToBoolean
Returns the boolean representation of an object or default value if not.
(Defined by CoreExtensions.)
Public Extension MethodToDateTime
Returns the DateTime representation of an object or default value if not.
(Defined by CoreExtensions.)
Public Extension MethodToDouble
Returns the double representation of an object or default value if not.
(Defined by CoreExtensions.)
Public Extension MethodToGuid
Returns the Guid representation of an object or default value if not.
(Defined by CoreExtensions.)
Public Extension MethodToInteger
Returns the integer representation of an object or default value if not.
(Defined by CoreExtensions.)
Public Extension MethodToString
Returns the string representation of an object or default value if not.
(Defined by CoreExtensions.)
Back to Top
Fields

  NameDescription
Public fieldStatic memberUSE_INDEXED_VIEWS
If true, the indexed views are used and generated within the system
Back to Top
Properties

  NameDescription
Public propertyConnectionString
Current connection string for the table management
Public propertyStatic memberDatabaseCulture
Database culture setting from the web.config.
Public propertyStatic memberDatabaseCultureInfo
Database culture info obtained from DatabaseCulture property.
Public propertyDatabaseName
Gets database name.
Public propertyDatabaseServerName
Gets database server name.
Public propertyDatabaseServerVersion
Gets database server version.
Public propertyDatabaseSize
Gets database size(including log size) in MB.
Public propertyDisableDebug
If true, the table manager disables debug for its queries
Protected propertyTableManagerObject
Table manager object
Public propertyStatic memberUpdateSystemFields
Determines whether system fields should be updated when updating table by schema.
Back to Top
See Also