More about the SQL::Connection Object
/pages/Ref/Api/Namespace/SQL/Connection/More about the SQL Connection Object.xml
While working in the Interactive window, after creating the conn SQL::Connection object, you could type.
Executing a SQL Query with the SQL::Connection Object
/pages/Server/Reference/Design/Data/SQL/Executing a SQL Query with the SQL Connection Object.xml
Return to the Interactive window and open a new connection to AlphaSports.MDB.
SQL::Connection ToGridComponentDataObject Method
/pages/Ref/Api/Namespace/SQL/Connection/ToGridComponentDataObject Method.xml
Fetch data to a Grid Component Data Object using a SQL Query.
SQL::Connection ClearSchemaCache Method
/pages/Ref/Api/Namespace/SQL/Connection/ClearSchemaCache Method.xml
Clear any schema data cached by the connection.
SQL::Connection CommitTransaction Method
/pages/Ref/Api/Namespace/SQL/Connection/CommitTransaction Method.xml
Apply a set of changes started with BeginTransaction.
SQL::Connection DropDatabase Method
/pages/Ref/Api/Namespace/SQL/Connection/DropDatabase Method.xml
Remove a database.
SQL::Connection ListDatabases Method
/pages/Ref/Api/Namespace/SQL/Connection/ListDatabases Method.xml
Return a list of databases from the current server.
SQL::Connection ListServers Method
/pages/Ref/Api/Namespace/SQL/Connection/ListServers Method.xml
Return a list of servers for the current connection Application Programming Interface(API).
SQL::Connection ValidateQuery Method
/pages/Ref/Api/Namespace/SQL/Connection/ValidateQuery Method.xml
Validate a SQL query on the connection.
SQL::Connection CreateIndex Method
/pages/Ref/Api/Namespace/SQL/Connection/CreateIndex Method.xml
Create an index on the specified table in the currently connected database using the TableInfo and IndexInfo specifications.