View Information About Database

Information about the database structure

To view the database structure, use the Database Explorer app. For details, see Working with Database Explorer.


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
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
columnprivileges List database column privileges
columns Return database table column names
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


Database Explorer Configure, explore, and import database data
Was this topic helpful?