Search results
26 lis 2015 · For Db2 for Linux, Unix and Windows (i.e. Db2 LUW) or for Db2 Warehouse use the SYSCAT.TABLES catalog view. E.g. SELECT TABSCHEMA, TABNAME FROM SYSCAT.TABLES WHERE TABSCHEMA LIKE '%CUR%' AND TYPE = 'T'
A fully qualified table name is a three-part name. The first part is a location name that designates the DBMS at which the table is stored. The second part is a schema name.
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.
The TABLE_NAME function searches for an object and returns the unqualified name of the object after any alias chains have been resolved. TABLE_NAME( object-name , object-schema , location-name ) The schema is DSN8.
18 cze 2013 · The below query should give you what you're looking for: use YourDatabase; go select object_schema_name (t.object_id) + '.' + t.name as table_name, c.name as column_name from sys.tables t inner join sys.columns c on t.object_id = c.object_id where c.name like '%ColumnSearchText%';
Queries below list tables in a specific schema. Query select tabname as table_name from syscat.tables where tabschema = 'schema_name' -- put schema name here and type = 'T' order by tabname
Do not begin names with a number or with the underscore character. Do not use SQL reserved words to name tables, views, columns, indexes, or authorization IDs. Use only the letters defined in the basic ASCII character set for directory and file names.
