View Information About Database

Information about the database structure


catalogs Get database catalog names
columns Return database table column names
schemas Get database schema names
tables Return database table names
get Retrieve object properties
getdatasources Return names of ODBC and JDBC data sources on system
isconnection (Not recommended) Determine if database connections are valid
isopen Determine if database connection or database cursor is open
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


Database Explorer Configure, explore, and import database data

Examples and How To

Was this topic helpful?