Connecting to and working with Databases (SQL, noSQL) and other data sources in Alpha Anywhere.
a5_recent_databases Function
/documentation/pages/Ref/Desktop_Api/Project/Database Functions/a5_recent_databases Function.xml
Returns a string in a menu format of the most recently used databases. Long file names are trimmed.
SQL::Connection ListDatabases Method
/documentation/pages/Ref/Api/Namespace/SQL/Connection/ListDatabases Method.xml
Return a list of databases from the current server.
Extension::CouchDB ListDatabases Method
/documentation/pages/Ref/Api/Namespace/Extension/CouchDB/ListDatabases Method.xml
Get top level database list.
Extension::MongoDB ListDatabases Method
/documentation/pages/Ref/Api/Namespace/Extension/MongoDB/ListDatabases Method.xml
Get top level database list.
Connecting to SQL Server
/documentation/pages/Guides/Databases/Connecting/Connecting to SQL Server.xml
Alpha Anywhere AlphaDAO provides an extension driver for SQL Server to simplify building connections using any of the SQL Server ODBC drivers provided by Microsoft. You must first install the appropriate driver for the version of your SQL Server database. In the connection string dialog, select the version of the database you are connecting to. Alpha Anywhere will select the installed driver that is the best fit for the target version.
Create Snapshots
/documentation/pages/Guides/Databases/Working with SQL/Create Snapshots/index.xml
Creating databases and table snapshots.
Database Utilities
Utilities and tools for working with databases in Alpha Anywhere.
Geographic Data
Working with and storing geographic data in databases.
udf_rename Function
/documentation/pages/Ref/Api/Functions/Xbasic/User Defined Functions/udf_rename Function.xml
Rename a udf (must include password if renaming a protected udf).