1.oracle数据库
select column_name
from user_tab_columns
where table_name = '表名'; --表名需要大写
2.sqlserver数据库
select syscolumns.name
from syscolumns , sysobjects
where syscolumns.id = sysobjects.id
select column_name
from user_tab_columns
where table_name = '表名'; --表名需要大写
2.sqlserver数据库
select syscolumns.name
from syscolumns , sysobjects
where syscolumns.id = sysobjects.id
and sysobjects.name = '表名'
原文链接:http://yanjiahua922.blog.163.com/blog/static/181557602201142621620575/