--test库
select d.name,a.name ,b.name ,a.length, a.isnullable
from test..syscolumns a, test..systypes b,test..sysobjects d
where a.xtype=b.xusertype and a.id=d.id and d.xtype= 'U '
--mysql库
select d.name,a.name ,b.name ,a.length, a.isnullable
from mysql..syscolumns a, mysql..systypes b,mysql..sysobjects d
where a.xtype=b.xusertype and a.id=d.id and d.xtype= 'U '
select d.name,a.name ,b.name ,a.length, a.isnullable
from test..syscolumns a, test..systypes b,test..sysobjects d
where a.xtype=b.xusertype and a.id=d.id and d.xtype= 'U '
--mysql库
select d.name,a.name ,b.name ,a.length, a.isnullable
from mysql..syscolumns a, mysql..systypes b,mysql..sysobjects d
where a.xtype=b.xusertype and a.id=d.id and d.xtype= 'U '