Search results
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.
3 paź 2018 · Quick and simple free tool to help you draw your database relationship diagrams and flow quickly using simple DSL language.
SchemaCrawler is a free database schema discovery and comprehension tool. It has grep functionality that allows you to search for table and column names using regular expressions.
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.
Generate the DDL statements for both the parent table TAB1 in schema TABLES and the dependent view of TAB1 that is called VIEW1 in the VIEWS schema in database DB1. The output is sent to the db2look.sql file.
11 lip 2011 · DB2 list schemas of a database. 11 July,2011 by Tom Collins. "How to do a DB2 list schemas ?" Step 1 – Connect to the database. view source print? 1. db2 connect to my_database. Step 2 – Execute this query. view source print? 1. select schemaname from syscat.schemata. If you want to connect to another schema - read DB2 SET CURRENT SCHEMA.
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
