--查询数据库中的全部表
select * from sysobjects where xtype='U' order by name
--查询表中的全部字段
Select name FROM SysColumns Where id=Object_Id('buy') order by colid
--查询数据库中的全部表
select * from sysobjects where xtype='U' order by name
--查询表中的全部字段
Select name FROM SysColumns Where id=Object_Id('buy') order by colid