我试图在db2中查询VIEWS中的数据，但查询不正确。
SELECT TRIM(NAME),TRIM(ADDRESS) from SYSCAT.VIEWS where TYPE = 'V' and TABSCHEMA = 'work.SCHEMA' and tabname IN ('EMPLOYEE');
方案〉视图〉雇员上面的查询只返回Employee中的数据
a8jjtwal1#
1.First Schema in query
查询：'建立结构描述schema_name'示例：“创建架构表”
2.create a view in query
查询：'创建视图view_name as select*from table_name'
wj8zmpe12#
只需单击链接即可了解架构和视图Go to learn a view in SqlGo to learn in schema in Sql
2条答案
按热度按时间a8jjtwal1#
查询：'建立结构描述schema_name'
示例：“创建架构表”
查询：'创建视图view_name as select*from table_name'
wj8zmpe12#
只需单击链接即可了解架构和视图
Go to learn a view in Sql
Go to learn in schema in Sql