SQL 如何检查 Teradata 表定义
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/26674898/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How to Check Teradata Table Definitions
提问by Kurai Bankusu
In my Teradata SQL Assistant Client, I can right-click a table and select Show Definition, this will display the column types and how they are defined.
在我的 Teradata SQL Assistant Client 中，我可以右键单击一个表并选择Show Definition，这将显示列类型及其定义方式。
Is there a query that can be run to give me the same output? More specifically I'm trying to display the definition of a view that is created from certain tables that I do not have SELECT or VIEW DEFINITION access to.
是否有可以运行的查询来给我相同的输出？更具体地说，我试图显示从我没有 SELECT 或 VIEW DEFINITION 访问权限的某些表创建的视图的定义。
回答by Spider
SHOW TABLE {Database_Name}.{Table_Name};
SHOW VIEW {Database_Name}.{View_Name};
