SqlAdmin MethodsNemiro.Data.dll

The SqlAdmin type exposes the following members.

Methods

  NameDescription
Public methodClearTable
Deletes all data from the specified table. Used TRUNCATE TABLE.
Public methodCreateTable(DataSet, Boolean)
Creates tables specified in the instance of DataSet.
Public methodCreateTable(DataTable, Boolean)
Creates a table in the database.
Public methodDeleteTable
Removes the specified table from the database.
Public methodDispose
Releases all resources used by the object.
Public methodEquals (Inherited from Object.)
Protected methodFinalize (Inherited from Object.)
Public methodGetAllTables
Returns a list of all the tables that are in the database.
Public methodGetAllTablesName
Returns the names of all the tables that exist in the database.
Public methodGetAllTablesSize
Returns the size of the database tables.
Public methodGetHashCode (Inherited from Object.)
Public methodGetSqlServerProperty
Returns the value of the specified property instance SQL Server.
Public methodGetSqlServerProprty
Returns the value of the specified property instance SQL Server.
Public methodGetSqlServerVersion
Returns the version of the instance SQL Server.
Public methodGetTableColums
Returns a list of all the columns of specified table.
Public methodGetTablePrimaryKey
Returns a primary key of specified table.
Public methodGetType (Inherited from Object.)
Protected methodMemberwiseClone (Inherited from Object.)
Public methodResetIdentity
Reset value of autoincrement field.
Public methodSetIdentityValue
Set new start value for autoincrement field.
Public methodTableIsExists(String)
Checks the existence of a specific table in the database.
Public methodTableIsExists(String, String)
Checks the existence of a specific table in the database.
Public methodToString (Inherited from Object.)
Top
See Also