DatabaseGetTableSchema

 

Dovico.TrackITWSAPI.API.DatabaseGetTableSchema(System.String,Dovico.TrackITAPI.SessionToken)

 

 

Function Overview:

This method returns a DataSet with only schema information for the specified table. This can be used to obtain field lengths, field types, names of fields etc.

 

 

Parameter List:

sTable - string - The name of the table to retrieve information for. Note that it will wrap all table names in [] to ensure SQL keyword safety

stToken - SessionToken - Session information needed to process the method call

 

Returns

A DataSet containing the schema for the specified table.

 

Example:

// get the database schema for the employees table

DataSet dsSchema = wsapi.DatabaseGetTableSchema("EMPLOYEE", stToken);