db2中 view是如何定义的?在哪儿可以看到VIEW有定义?

-布谷鸟- 2007-09-24 04:15:28
我想看VIEW的定义,它在哪里放着?
...全文
85 3 打赏 收藏 转发到动态 举报
写回复
用AI写文章
3 条回复
切换为时间正序
请发表友善的回复…
发表回复
welyngj 2007-09-26
  • 打赏
  • 举报
回复
The catalog includes the following views and tables in the QSYS2 library:
DB2 UDB for AS/400 name ANSI/ISO name Description
SQL_LANGUAGES SQL_LANGUAGES Information about the supported languages
SYSCHKCST CHECK_CONSTRAINTS Information about check constraints
SYSCOLUMNS COLUMNS Information about column attributes
SYSCST TABLE_CONSTRAINTS Information about all constraints
SYSCSTCOL CONSTRAINT_COLUMN_USAGE Information about the columns referenced in a constraint
SYSCSTDEP CONSTRAINT_TABLE_USAGE Information about constraint dependencies on tables
SYSFUNCS ROUTINES Information about user-defined functions
SYSINDEXES
Information about indexes
SYSKEYCST KEY_COLUMN_USAGE Information about unique, primary, and foreign keys
SYSKEYS
Information about index keys
SYSPACKAGE
Information about packages
SYSPARMS PARAMETERS Information about routine parameters
SYSPROCS ROUTINES Information about procedures
SYSREFCST REFERENTIAL_CONSTRAINTS Information about referential constraints
SYSROUTINES ROUTINES Information about functions and procedures
SYSTABLES TABLES Information about tables and views
SYSTYPES USER_DEFINED_TYPES Information about user-defined types
SYSVIEWDEP VIEW_TABLE_USAGE Information about view dependencies on tables
SYSVIEWS VIEWS Information about definition of a view
-布谷鸟- 2007-09-26
  • 打赏
  • 举报
回复
AS/400上的DB2,好象与NT/AIX上的DB2不同哟. 按以上方法找不到.
welyngj 2007-09-25
  • 打赏
  • 举报
回复
select text
from sysibm.sysviews

C:\>db2 describe table sysibm.sysviews

Column Type Type
name schema name Length Scale Nulls

------------------------------ --------- ------------------ -------- ----- -----
-
NAME SYSIBM VARCHAR 128 0 No

CREATOR SYSIBM VARCHAR 128 0 No

CHECK SYSIBM CHARACTER 1 0 No

TEXT SYSIBM CLOB 2097152 0 No

FUNC_PATH SYSIBM VARCHAR 254 0 No

VALID SYSIBM CHARACTER 1 0 No

READONLY SYSIBM CHARACTER 1 0 No

DEFINER SYSIBM VARCHAR 128 0 No

QUALIFIER SYSIBM VARCHAR 128 0 No

5,889

社区成员

发帖
与我相关
我的任务
社区描述
IBM DB2 是美国IBM公司开发的一套关系型数据库管理系统,它主要的运行环境为UNIX(包括IBM自家的AIX)、Linux、IBM i(旧称OS/400)、z/OS,以及Windows服务器版本
社区管理员
  • DB2
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧