elect a.name as [column],b.name as type
from syscolumns a,systypes b
where a.id=object_id('表名') and a.xtype=b.xtype
把「表名」替換成你要查看欄位類型的表名,比如你要查看sysobjects表的各欄位類型那麼就是
select a.name as [column],b.name as type
from syscolumns a,systypes b
where a.id=object_id('sysobjects') and a.xtype=b.xtype
另外可以通過存儲過程
exec sp_help 表名
[admin via ] mysql查詢某個表中有哪些欄位類型已經有869次圍觀