Add column to specified table.

Alters specified procedure in database

Rename, retype or allow/not allow NULL values in column

Alter table column with default value.

Creates specified view in database

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.

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.

Changes database object owner.

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.

Converts object to a query value which can be used as a query parameter

Gets the string by the specified resource key

Gets the string by the specified resource key

Returns the boolean representation of an object or default value if not.

Returns the DateTime representation of an object or default value if not.

Returns the double representation of an object or default value if not.

Returns the Guid representation of an object or default value if not.

Returns the integer representation of an object or default value if not.

Returns the string representation of an object or default value if not.