汽车系统sql表2
时间：2008-07-04 来源：ziyouwawa
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CarInsurance]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CarInsurance]
GO CREATE TABLE [dbo].[CarInsurance] (
[policyID] [int] IDENTITY (1, 1) NOT NULL ,
[RegistMark] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[StartDate] [datetime] NOT NULL ,
[EndDate] [datetime] NOT NULL ,
[SignDate] [datetime] NOT NULL ,
[PolicyPrice] [money] NOT NULL
) ON [PRIMARY]
GO
drop table [dbo].[CarInsurance]
GO CREATE TABLE [dbo].[CarInsurance] (
[policyID] [int] IDENTITY (1, 1) NOT NULL ,
[RegistMark] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[StartDate] [datetime] NOT NULL ,
[EndDate] [datetime] NOT NULL ,
[SignDate] [datetime] NOT NULL ,
[PolicyPrice] [money] NOT NULL
) ON [PRIMARY]
GO
相关阅读 更多 +
