问到了好多方法,哈哈,记录一下:
exec sp_help 'kbmp.kmms.tmp_wy'
select * from information_schema.columns where table_name='tmp_wy'
sp_MShelpcolumns 'kbmp.kmms.tmp_wy'
exec sp_help 'kbmp.kmms.tmp_wy'
select * from information_schema.columns where table_name='tmp_wy'
sp_MShelpcolumns 'kbmp.kmms.tmp_wy'