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".
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.
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.
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.
29 maj 2015 · SELECT TABLE_OWNER, TABLE_NAME FROM FROM QSYS2.SYSTABLES Where TABLE_OWNER is the schema, and TABLE_NAME is the name. You should find various other useful views in the catalog like SYSVIEWS, SYSCOLUMNS, SYSTRIGGERS, etc. It may be worth downloading the PDFs of the old DB2 for iSeries docs which still seem to be available. I suspect the info on ...
SYSTABLES is the DB2 standard catalog view. Where you find it depends on which flavor of DB2 server you are using: DB2 for i, LUW, or z/OS. You shouldn't need GO or other such fiddle-faddle. Right click on a statement in the SQL file editor, and you'll see options like alt-S to execute current text.
