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.
16 kwi 2015 · How to view the table structure in db2 database. Open db2 command window, connect to db2 with following command. > db2 connect to DATABASE_NAME USER USERNAME USING PASSWORD. Once you connected successfully, issue the following command to view the table structure. > db2 "describe select * from SCHEMA_NAME.TABLE_NAME".
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.
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
A schema can contain tables, views, nicknames, triggers, functions, packages, and other objects. A schema is itself a database object. It is explicitly created using the CREATE SCHEMA statement, with the current user or a specified authorization ID recorded as the schema owner.
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.
11 lip 2011 · 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. The recordset is something like : Read More. DB2 SET CURRENT SCHEMA - DBA DB2.
