Teradata
数据库TableKind表类型对应
[sql]
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 'Table'
WHEN T.TableKind = 'U' THEN 'User-defined data type'
WHEN T.TableKind = 'V' THEN 'View'
WHEN T.TableKind = 'X' THEN 'Authorization'