simx

获取用户库  ： select * from sysobjects where xtype=u根据库获取表 ： select * from 库名.dbo.sysobjects根据表ID获取表字段 ：select * from syscolumns where id=表ID      或者    select * from 库名.dbo.syscolumns where id

查询所有表   select Sysobjects.Name from SysObjects查询所有类型   select SysTypes.Name from SysTypes查询所有列   select SysColumns.Name from SysColumns查询列长度 select SysColumns.length from SysColumns查询库 select

表：a,b字段：a.id,a.fid,a.name         b.id,b.nameupdate a set a.name=b.name from b where a.fid=b.id

select distinct name from table