SQL Classes

Namespace	Class	Description
VO	SQLCatalogQuery	Provide the base class from which all X# catalog classes are subclassed.
VO	SQLColumn	Describe an SQL column.
VO	SQLColumnAttributes	Describe the attributes of an SQL column.
VO	SQLConnection	Manage an SQL connection to an ODBC data source. A SQLConnection object is needed before any database operations can be performed.
VO	SQLData	Represent an SQL data value; used internally by SQL classes.
VO	SqlData_Union
VO	SQLErrorInfo	Describe a SQL error.
VO	SQLListColumnPrivileges	List the columns and associated privileges for one or more tables.
VO	SQLListColumns	List the column names in specified tables.
VO	SQLListForeignKeys	List the column names that comprise foreign keys, if they exist for a specified table.
VO	SQLListPrimaryKeys	List the column names that comprise the primary key for a table.
VO	SQLListProcedureColumns	List the input and output procedure parameters and columns that make up the result set for the specified procedures.
VO	SQLListProcedures	List the procedure names stored in a specific data source.
VO	SQLListSpecialColumns	List information about the optimal set of columns that uniquely identifies a row in a specified table or the columns that are updated automatically when any value in the row is updated by a transaction.
VO	SQLListStatistics	List the table statistics and the indexes.
VO	SQLListTablePrivileges	List the tables and associated privileges.
VO	SQLListTables	List the table names stored in a specific data source.
VO	SQLListTypeInfo	List the ODBC data types that are supported by this connection.
VO	SqlParameter	T:VO.SqlParameterSQL.xmldoc/SqlParameter/*
VO	SQLSelect	Manage a SQL select statement to select a set of rows from an ODBC data source. The rows can be read, modified, or deleted using the SQLSelect methods.
VO	SQLStatement	Manage a SQL statement.
VO	SQLTable	Manage a table.
VO	SQLValue	Describe a SQL value.
XSharp.Data	AbstractSqlFactory	This is the base class for most ISqlFactory implementations.
XSharp.Data	ISqlFactory	This interface declares the common behavior for all XSharp Data Factory classes.
XSharp.Data	OdbcFactory	This is the class that implements a Factory to access data through the Ado.Net ODBC Classes.
XSharp.Data	OleDbFactory	This is the class that implements a Factory to access data through the Ado.Net Microsoft SQL Server classes.
XSharp.Data	SqlServerFactory	This is the class that implements a Factory to access data through the Ado.Net Microsoft SQL Server classes.
XSharp.RDD	SQLProperty	Enum that matches the various FoxPro Sql properties, used in SqlGetProp() and SqlSetProp()
XSharp.VO.SDK	SQLCatalogQuery	Provide the base class from which all X# catalog classes are subclassed.
XSharp.VO.SDK	SQLColumn	Describe an SQL column.
XSharp.VO.SDK	SQLColumnAttributes	Describe the attributes of an SQL column.
XSharp.VO.SDK	SQLConnection	Manage an SQL connection to an ODBC data source. A SQLConnection object is needed before any database operations can be performed.
XSharp.VO.SDK	SQLData	Represent an SQL data value; used internally by SQL classes.
XSharp.VO.SDK	SQLErrorInfo	Describe a SQL error.
XSharp.VO.SDK	SQLListColumnPrivileges	List the columns and associated privileges for one or more tables.
XSharp.VO.SDK	SQLListColumns	List the column names in specified tables.
XSharp.VO.SDK	SQLListDatabases	T:XSharp.VO.SDK.SQLListDatabasesSql.xmldoc/SQLListDatabases/*
XSharp.VO.SDK	SQLListForeignKeys	List the column names that comprise foreign keys, if they exist for a specified table.
XSharp.VO.SDK	SQLListIndexColumns	T:XSharp.VO.SDK.SQLListIndexColumnsSql.xmldoc/SQLListIndexColumns/*
XSharp.VO.SDK	SQLListIndexes	T:XSharp.VO.SDK.SQLListIndexesSql.xmldoc/SQLListIndexes/*
XSharp.VO.SDK	SQLListPrimaryKeys	List the column names that comprise the primary key for a table.
XSharp.VO.SDK	SQLListProcedureColumns	List the input and output procedure parameters and columns that make up the result set for the specified procedures.
XSharp.VO.SDK	SQLListProcedureParameters	T:XSharp.VO.SDK.SQLListProcedureParametersSql.xmldoc/SQLListProcedureParameters/*
XSharp.VO.SDK	SQLListProcedures	List the procedure names stored in a specific data source.
XSharp.VO.SDK	SQLListReservedWords	T:XSharp.VO.SDK.SQLListReservedWordsSql.xmldoc/SQLListReservedWords/*
XSharp.VO.SDK	SQLListRestrictions	T:XSharp.VO.SDK.SQLListRestrictionsSql.xmldoc/SQLListRestrictions/*
XSharp.VO.SDK	SQLListSpecialColumns	List information about the optimal set of columns that uniquely identifies a row in a specified table or the columns that are updated automatically when any value in the row is updated by a transaction.
XSharp.VO.SDK	SQLListStatistics	List the table statistics and the indexes.
XSharp.VO.SDK	SQLListTablePrivileges	List the tables and associated privileges.
XSharp.VO.SDK	SQLListTables	List the table names stored in a specific data source.
XSharp.VO.SDK	SQLListTriggers	T:XSharp.VO.SDK.SQLListTriggersSql.xmldoc/SQLListTriggers/*
XSharp.VO.SDK	SQLListTypeInfo	List the ODBC data types that are supported by this connection.
XSharp.VO.SDK	SQLListUsers	T:XSharp.VO.SDK.SQLListUsersSql.xmldoc/SQLListUsers/*
XSharp.VO.SDK	SQLListViewColumns	T:XSharp.VO.SDK.SQLListViewColumnsSql.xmldoc/SQLListViewColumns/*
XSharp.VO.SDK	SQLListViews	T:XSharp.VO.SDK.SQLListViewsSql.xmldoc/SQLListViews/*
XSharp.VO.SDK	SqlParameter	T:XSharp.VO.SDK.SqlParameterSql.xmldoc/SqlParameter/*
XSharp.VO.SDK	SQLSelect	Manage a SQL select statement to select a set of rows from an ODBC data source. The rows can be read, modified, or deleted using the SQLSelect methods.
XSharp.VO.SDK	SQLStatement	Manage a SQL statement.
XSharp.VO.SDK	SQLTable	Manage a table.
XSharp.VO.SDK	SQLValue	Describe a SQL value.