就是有19个类似以下的SQL语句,要在ORACLE里产生19个表
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].[报警事件] (
[报警事件类型] [int] NOT NULL ,
[事件处理状态] [int] NOT NULL ,
[事件日期] [int] NOT NULL ,
[事件时间] [int] NOT NULL ,
[关联档案ID] [char] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[关联TN] [int] NOT NULL ,
[关联FN] [int] NOT NULL ,
[事件内容] [TEXT] COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO