View Information About Database

Information about database data

Functions

database.catalogs Get database catalog names
database.columns Get database table column names
database.schemas Get database schema names
database.tables Get database table names
get Retrieve object properties
getdatasources Return names of ODBC and JDBC data sources on system
isconnection Determine if database connections are valid
isreadonly Determine if database connection is read only
ping Retrieve status information about database connection
bestrowid Unique identifier for row in database table
columnprivileges List database column privileges
columns Return database table column names
crossreference Retrieve information about primary and foreign keys
dmd Construct database metadata object
exportedkeys Retrieve information about exported foreign keys
importedkeys Return information about imported foreign keys
indexinfo Return indices and statistics for database tables
primarykeys Get primary key information for database table or schema
procedurecolumns Get stored procedure parameters and result columns of catalogs
procedures Get stored procedures for catalogs
supports Detect whether property is supported by database metadata object
tableprivileges Return database table privileges
tables Return database table names
versioncolumns Automatically update table columns
dexplore Start SQL Database Explorer to import data
Was this topic helpful?