Search results
16 kwi 2015 · The Db2 catalogs hold lots of information about table structure. You can query them to find (most) things out about the structure of a table. For example, you can generate (approximate) DDL for Db2 LUW tables from the catalog with SQL such as contained in this view from the IBM samples.
30 wrz 2008 · SELECT * FROM SYSIBM.VIEWS -- Provides all views and their source (!!) definition. SELECT * FROM SYSIBM.COLUMNS -- Provides all columns, their data types & sizes, default values, etc. SELECT * FROM SYSIBM.SQLPRIMARYKEYS -- Provides a list of primary keys and their order. answered Jul 26, 2011 at 17:13.
The DESCRIBE command displays metadata about the columns, indexes, and data partitions of tables or views. This command can also display metadata about the output of SELECT, CALL, or XQuery statements.
To explore the tables of a DB2® database schema in an overview diagram, follow these steps: In the Data Source Explorer, connect to a DB2 database, for example, DWESAMP, and navigate to the Schemas folder. Expand the Schemas folder, right-click a schema, for example, BANK, and select Add to Overview Diagram from the popup menu.
A schema provides a logical classification of objects in the database. The objects that a schema can contain include tables, indexes, table spaces, distinct types, functions, stored procedures, and triggers.
24 cze 2018 · Query below finds all views in a database with their script. Query select viewschema as schema_name, viewname as view_name, text as definition from syscat.views where viewschema not like 'SYS%' order by schema_name, view_name Columns. schema_name - schema name of the view; view_name - name of the view
10 cze 2019 · Find tables and views used by specific view in Db2 database - IBM Db2 Query Toolbox. Article for: IBM Db2 . Query below lists all dependencies of view to other view or table. select tabschema as schema_name, tabname as view_name, case btype.
