Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 (中文) » SQL Anywhere 服务器 - SQL 参考 » 视图 » 统一视图

 

SYSVIEWS 统一视图

SYSVIEWS 视图的每一行都描述一个视图,包括其视图定义。

在以下的 SQL 语句中提供了组成该视图的表和列。要了解有关特定表或列的详细信息,请使用该视图定义下所提供的链接。

ALTER VIEW "SYS"."SYSVIEWS"( vcreator,
  viewname,viewtext ) 
  as select u.user_name,t.table_name,v.view_def
    from SYS.ISYSTAB as t
      join SYS.ISYSVIEW as v on(t.object_id = v.view_object_id)
      join SYS.ISYSUSER as u on(u.user_id = t.creator)
 另请参见