Oracle: select * from sys.col where tname = 'tablename' SqlServer:select * from syscolumns where id =(select id from sysobjects where name = 'tablename')
''''Get table's columns from SQL Server SELECT a.name col,b.name type,a.length length FROM syscolumns a,systypes b,sysobjects c WHERE a.xtype=b.xtype AND a.id=c.id AND b.name NOT LIKE '%sys%' AND c.name='TableName'''''Get table's columns from SQL Server SELECT column_name col,data_type type,data_length length FROM all_tab_columns WHERE owner='User' AND table_name='TableName'
笨办法,执行:select * from table where 0 <> 0,把结果放到DataTable里,然后访问DataTable的Columns就可以了,呵呵。
SqlServer:select * from syscolumns where id =(select id from sysobjects where name = 'tablename')
http://community.csdn.net/Expert/topicview.asp?id=1679569
SELECT a.name col,b.name type,a.length length
FROM syscolumns a,systypes b,sysobjects c
WHERE a.xtype=b.xtype
AND a.id=c.id
AND b.name NOT LIKE '%sys%'
AND c.name='TableName'''''Get table's columns from SQL Server
SELECT column_name col,data_type type,data_length length
FROM all_tab_columns
WHERE owner='User'
AND table_name='TableName'