Select Name as 新建表名 from GGDoctor..sysobjects where xtype='U' and Crdate between 开始时间 and 结束时间--生成脚本要手动生成
select a.name tname,b.name colname,TYPE_NAME(b.xtype) coltype,b.length colenght,b.isnullable ifnull from sysobjects a inner join syscolumns b on a.id=b.id where a.xtype='U'
1.利用语句查找满足条件的表 Select name From sysobject Where xtype='U' AND crdate between 开始时间 and 结束时间2.利用工具导出表脚本
where xtype='U' and Crdate between 开始时间 and 结束时间--生成脚本要手动生成
Select name From sysobject Where xtype='U' AND crdate between 开始时间 and 结束时间2.利用工具导出表脚本