Add column to specified table.

Alters specified procedure in database

Alter table column with default value.

Alters specified view in database

Changes database object owner.

Checks if column name is unique in given view.

Creates the table indexes.

Creates specified procedure in database

Creates specified table in database.

Creates specified table in database.

Returns a transaction scope that can be used to maintain database consistency.

Creates specified view in database

Deletes data from specified table.

Removes view or stored procedure from database.

Drops the column indexes, returns the DataSet of indexes.

Drops the default constraint.

Drop specified table from database.

Remove column from specified table.

Drop specified view from database. Returns the schema of the dropped view

Add apostrophes around the column default value string according to column type.

Executes query and returns the results in a DataSet.

Executes query and returns the results in a DataSet.

Returns SQL code of specified view or stored procedure.

Returns the DataSet of column indexes.

Returns DataSet with specified table column information retrieved from database information schema. Returns columns ColumnName, DataType, DataSize, DataPrecision, Nullable, DefaultValue.

Gets the connection for the table management

Gets size related information about the database.

Gets database size (including log size) or N/A string if the size cannot be retrieved

Gets the database version

Returns DataSet with indexes of the given object. Returns columns IndexName, DropScript, CreateScript

Returns list of views or stored procedures.

Returns the name of the primary key constraint.

Returns list of column names which represent primary keys of the specified database table. Returns empty list if primary keys are not found.

Gets list of object names which have foreign key constraint dependency.

Returns name of the primary key. If more columns in PK, names are separated by semicolon ";".

Gets the tables in the current database

Returns the value string using the database culture. Does not include apostrophes for types that need them

Returns XML schema for specified table.

Drops the current primary key constraint and creates new from given columns.

Refreshes specified view in database.

Changes name of the column.

Changes name of the table with original name according to the new name.

Determines whether specified stored procedure exists or not.

Determines whether specified DB table exists or not.

Determines whether specified DB view exists or not.

Determines whether specified DB view exists or not.