Creation nouvelle table + test

Admin Lun 7 Juil - 11:06

Code:: /****** Object: Table [dbo].[APP_GROUP] Script Date: 7/7/2008 10:05:30 AM ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[APP_GROUP]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[APP_GROUP] GO if not exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[APP_GROUP]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) BEGIN CREATE TABLE [dbo].[APP_GROUP] ( [ID_APP_GROUP] [int] IDENTITY (1, 1) NOT NULL , [DESCRIPTION] [varchar] (-1) COLLATE French_CI_AS NULL , [VALID] [bit] NULL , CONSTRAINT [PK_APP_GROUP] PRIMARY KEY CLUSTERED ( [ID_APP_GROUP] ) ON [PRIMARY] ) ON [PRIMARY] END GO