获取Sqlserver中表字段名类型注释等信息

需求：为实现sqlserver到hive(impala)自动化建表，需要获取sqlserver表字段信息进行拼接

表名作为参数传入，直接上代码，如下：
SELECT A.NAME AS COLUMN_NAME, B.NAME AS DATA_TYPE, ISNULL(G.[VALUE],'') AS COMMENTS FROM SYSCOLUMNS A LEFT JOIN SYSTYPES B ON A.XTYPE=B.XUSERTYPE LEFT JOIN SYS.EXTENDED_PROPERTIES G ON A.ID=G.MAJOR_ID AND A.COLID = G.MINOR_ID WHERE A.ID=OBJECT_ID('${table_name}')
效果如下：