我用SQL查询分析器，命令建立数据表：
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[记录]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[记录]
GO
CREATE TABLE [dbo].[记录] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[标识] [numeric](18, 0) NULL ,
[时间] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[记录] [varchar] (8000) COLLATE Chinese_PRC_CI_AS NULL ,
[值班员] [varchar] (8) COLLATE Chinese_PRC_CI_AS NULL ,
[年份] [smallint] NULL ,
[月份] [tinyint] NULL ,
[日期] [tinyint] NULL
) ON [PRIMARY]
GO
没有注意将“记录”表改名，重复了然后表就变成新的了，原来的数据也就没有了！请问怎么恢复原来的数据呀？？

我顶