Teradata数据库TableKind表类型对应,
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
本站文章为和通数据库网友分享或者投稿,欢迎任何形式的转载,但请务必注明出处.
同时文章内容如有侵犯了您的权益,请联系QQ:970679559,我们会在尽快处理。