如何从给定的表中检索列名? [英] how do i retrive column names from a given table?

问题描述

当表名作为sql查询的参数提供时，我需要从数据库中检索列名.

 选择 c.name  as  SC_DATA_COL_NAME 其中​​ v.object_id = c.object_id  @ name )

这里@name用作参数

上面的查询在sql server上工作正常，但在DB2上却不行，请给出一些建议以创建在DB2上运行的查询. = @name

我稍微更改了解决方案1，然后效果很好

从SYSIBM.COLUMNS中选择DISTINCT COLUMN_NAME
在哪里TABLE_NAME = @ name

i need to retrieve column names from a database, when a table name provide as a parameter to the sql query.

select c.name as SC_DATA_COL_NAME  from sys.tables v,sys.columns c where v.object_id=c.object_id and upper(v.name)=upper(@name) 

here @name is used as a parameter

above query works fine in sql server but not in DB2, please give some suggestion to create a query which runs on DB2.

解决方案

SELECT NAME AS SC_DATA_COL_NAME FROM SYSCOLUMNS WHERE TBNAME = @name

I changed solution 1 little bit then it works fine

SELECT DISTINCT COLUMN_NAME FROM SYSIBM.COLUMNS
WHERE TABLE_NAME=@name

这篇关于如何从给定的表中检索列名?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！