[Missing <summary> documentation for "N:DatabaseObjects.SQL"]

Classes

  Class Description
Public class SQLAggregateExpression
Public class SQLAllFieldsExpression
Represents '*' or 'T.*' when used to select all fields from a table or join.
Public class SQLAlterTable
Public class SQLArithmeticExpression
Public class SQLAutoIncrementValue
Public class SQLBeginTransaction
Public class SQLBitwiseExpression
Public class SQLCaseExpression
Allows the use of CASE statements. Specifically: Simple CASE expression: CASE input_expression WHEN when_expression THEN result_expression [ ...n ] [ ELSE else_result_expression ] END Searched CASE expression: CASE WHEN Boolean_expression THEN result_expression [ ...n ] [ ELSE else_result_expression ] END
Public class SQLCaseExpression..::..Case
Public class SQLCaseExpression..::..CasesCollection
Public class SQLCastExpression
Public class SQLCommitTransaction
Public class SQLCondition
Public class SQLConditionExpression
Public class SQLConditionFieldCompare
Public class SQLConditionInSelect
Public class SQLConditions
Public class SQLConditionSelect
Public class SQLCreateIndex
Public class SQLCreateTable
Public class SQLCreateView
Public class SQLDelete
Public class SQLDropIndex
Public class SQLDropTable
Public class SQLDropView
Public class SQLExpression
Public class SQLFieldAggregateExpression
Public class SQLFieldExpression
Public class SQLFieldValue
Public class SQLFieldValues
Public class SQLFunctionExpression
Allows an SQL function to utilised in a WHERE clause or as a calculated column.
Public class SQLGetDateFunctionExpression
Public class SQLIndexField
Public class SQLIndexFields
Public class SQLInsert
Public class SQLInsertFromSelect
Allows data to be inserted using records from another table.
Public class SQLInsertFromSelect..::..FieldsClass
Public class SQLLeftFunctionExpression
Public class SQLLengthFunctionExpression
SQL function that returns the length of a string.
Public class SQLRightFunctionExpression
Public class SQLRollbackTransaction
Public class SQLSelect
Public class SQLSelectExpression
Public class SQLSelectField
Public class SQLSelectFields
Public class SQLSelectGetDate
Public class SQLSelectGroupByField
Public class SQLSelectGroupByFields
Public class SQLSelectHavingCondition
Public class SQLSelectHavingConditions
Public class SQLSelectOrderByField
Public class SQLSelectOrderByFields
Public class SQLSelectTable
Public class SQLSelectTableBase
Public class SQLSelectTableFromSelect
Public class SQLSelectTableJoin
Public class SQLSelectTableJoinCondition
Public class SQLSelectTableJoinConditions
Public class SQLSelectTableJoins
Public class SQLSelectTables
Public class SQLSetTransactionIsolationLevel
Public class SQLStatement
Public class SQLStatements
Public class SQLStringConcatExpression
Public class SQLTableExists
This class can be used to determine whether a table exists. This class can be used will all databases. If after running the SQL statement the data set is not empty then the table exists.
Public class SQLTableField
Represents a new database field to be created or added to a database table.
Public class SQLTableFieldBase
Public class SQLTableFieldComputed
Public class SQLTableFields
Public class SQLUnion
Public class SQLUpdate
Public class SQLUpdateField
Public class SQLUpdateFields
Public class SQLValueExpression
Public class SQLViewExists
This class can be used to determine whether a view exists. This class can be used will all databases. If after running the SQL statement the data set is not empty then the view exists.

Interfaces

  Interface Description
Public interface ISQLStatement

Enumerations

  Enumeration Description
Public enumeration AggregateFunction
Public enumeration ArithmeticOperator
Public enumeration BitwiseOperator
Public enumeration ComparisonOperator
Public enumeration DataType
Provides a set of uniform and portable data types that can be used between Microsoft Access, SQLServer and MySQL. Please refer to the DataTypeString function in the Source\SQL\SQLTable.vb file for the actual SQL equivalents for each database.
Public enumeration FieldValueAutoAssignmentType
Public enumeration KeyType
Public enumeration LogicalOperator
Public enumeration OrderBy
Public enumeration SQLSelectTableJoin..::..Type
Public enumeration SQLUnion..::..Type