Netezza是否具有ODBC DESCRIBE功能? [英] Does Netezza have an ODBC DESCRIBE function?

问题描述

我想描述一个保存在Netezza上的表(这样可以看到变量格式，在子句上分布等).我知道使用

I would like to DESCRIBE a table held on Netezza (so can see the variable formats, distribute on clause etc). I know this is possible (natively) using

\d <tablename>

但是我正在使用SAS进行连接(通过ODBC).

However I am using SAS to connect (via ODBC).

使用SAS 9.1.3代码是否可能?

Is this possible using SAS 9.1.3 code?

推荐答案

您将需要访问保存有关表信息的系统视图.您无法在一个查询中执行此操作，但可以在两个查询中执行此操作.

You would need to access the system views that hold the information about the tables. You can't do this in one query, but you can do it with two.

SELECT  attname "Attribute", 
        datatype "Type", 
        CASE WHEN attnotnull='t' THEN 
            'Not Null' 
        ELSE 
            'Null' 
        END "Modifier",
        coldefault "Default"
FROM _v_relation_column col_t
    cross join _v_datatype dat_t
WHERE dat_t.objid = col_t.atttypid
    AND name='<table_name>'
ORDER BY attnum
;

SELECT attname  "Distributed on hash"
FROM _v_table_dist_map
    INNER JOIN tb_nm t ON tname = tablename
WHERE tablename ='<table_name>'
;

这篇关于Netezza是否具有ODBC DESCRIBE功能?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！