1. oracle
查询某个表的字段名:
`select column_name from user_tab_columns where table_name='tableName'`
多行合并为一行,便于操作,可以用 wm_concat :
`select wm_concat(column_name) from user_tab_columns where table_name='tableName'`
2.SQLServer
查询表的字段名:
select name from syscolumns where id=object_id('tableName');
注意:需要在要查询的数据库下操作。
多行合并一行:
select( select RTRIM(name) + ',' from syscolumns where id=object_id('tableName') FOR XML PATH ('') ) as ddd