现在的位置: 首页 > 综合 > 正文

Teradata数据库TableKind表类型对应

2018年02月18日 ⁄ 综合 ⁄ 共 807字 ⁄ 字号 评论关闭
            WHEN T.TableKind = 'A' THEN 'Aggregate function'
            WHEN T.TableKind = 'B' THEN 'Combined aggregate and ordered analytical function'
            WHEN T.TableKind = 'D' THEN 'JAR'
            WHEN T.TableKind = 'E' THEN 'External Stored Procedure'
            WHEN T.TableKind = 'F' THEN 'Standard function'
            WHEN T.TableKind = 'G' THEN 'Trigger'
            WHEN T.TableKind = 'H' THEN 'Instance or Constructor Method'
            WHEN T.TableKind = 'I' THEN 'Join Index'
            WHEN T.TableKind = 'J' THEN 'Journal'
            WHEN T.TableKind = 'M' THEN 'Macro'
            WHEN T.TableKind = 'N' THEN 'Hash Index'
            WHEN T.TableKind = 'P' THEN 'SQL Procedure'
            WHEN T.TableKind = 'Q' THEN 'Queue Table'
            WHEN T.TableKind = 'R' THEN 'Table function'
            WHEN T.TableKind = 'S' THEN 'Ordered analytical function'
            WHEN T.TableKind = 'T' THEN 'SET TABLE'
            WHEN T.TableKind = 'U' THEN 'User-defined data type'
            WHEN T.TableKind = 'V' THEN 'View'
            WHEN T.TableKind = 'X' THEN 'Authorization'

WHEN TableKind = 'O' THEN 'MULTISET TABLE' // 可能是INDEX或者UNIQUE INDEX

抱歉!评论已关闭.