SqlServer：select c.name from sys.objects o join sys.columns c on o.object_id=c.object_id where o.name='表名';
Oracle: select column_name from user_tab_columns where table_name='tablename';
本文共 255 字，大约阅读时间需要 1 分钟。
SqlServer：select c.name from sys.objects o join sys.columns c on o.object_id=c.object_id where o.name='表名';
Oracle: select column_name from user_tab_columns where table_name='tablename';
转载于:https://www.cnblogs.com/fhuafeng/archive/2013/05/30/3108180.html