Common SQL Server Base de datos

ÿþ/****** Object: ForeignKey [FK_Detalle_Proyectos_Productos] Script Date: 07/06/2010 16:50:38 ******/

IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Detalle_Proyectos_Productos]') AND parent_object_id = OBJECT_ID(N'[dbo].[Detalle_Proyectos]'))

ALTER TABLE [dbo].[Detalle_Proyectos] DROP CONSTRAINT [FK_Detalle_Proyectos_Productos]

GO

/****** Object: ForeignKey [FK_Detalle_Proyectos_Proyectos] Script Date: 07/06/2010 16:50:38 ******/

IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Detalle_Proyectos_Proyectos]') AND parent_object_id = OBJECT_ID(N'[dbo].[Detalle_Proyectos]'))

ALTER TABLE [dbo].[Detalle_Proyectos] DROP CONSTRAINT [FK_Detalle_Proyectos_Proyectos]

GO

/****** Object: Table [dbo].[Detalle_Proyectos] Script Date: 07/06/2010 16:50:38 ******/

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Detalle_Proyectos]') AND type in (N'U'))

DROP TABLE [dbo].[Detalle_Proyectos]

GO

/****** Object: Table [dbo].[Productos] Script Date: 07/06/2010 16:50:38 ******/

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Productos]') AND type in (N'U'))

DROP TABLE [dbo].[Productos]

GO

/****** Object: Table [dbo].[Proyectos] Script Date: 07/06/2010 16:50:38 ******/

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Proyectos]') AND type in (N'U'))

DROP TABLE [dbo].[Proyectos]

GO

/****** Object: Table [dbo].[Proyectos] Script Date: 07/06/2010 16:50:38 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Proyectos]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[Proyectos](

[IDPROYECTO] [bigint] NOT NULL,

[NOMBRE] [varchar](100) COLLATE Modern_Spanish_CI_AS NOT NULL,

[EMPRESA] [varchar](100) COLLATE Modern_Spanish_CI_AS NOT NULL,

[ESTADO] [varchar](5) COLLATE Modern_Spanish_CI_AS NOT NULL,

[FECHA_INICIO] [date] NULL,

[OBSERVACIONES] [varchar](4000) COLLATE Modern_Spanish_CI_AS NULL,

CONSTRAINT [PK_Proyectos] PRIMARY KEY CLUSTERED

(

[IDPROYECTO] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)

)

END

GO

/****** Object: Table [dbo].[Productos] Script Date: 07/06/2010 16:50:38 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Productos]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[Productos](

[IDPRODUCTO] [bigint] NOT NULL,

[NOMBRE] [varchar](100) COLLATE Modern_Spanish_CI_AS NOT NULL,

[DESCRIPCION] [varchar](100) COLLATE Modern_Spanish_CI_AS NULL,

[TIPO] [varchar](5) COLLATE Modern_Spanish_CI_AS NULL,

CONSTRAINT [PK_Productos] PRIMARY KEY CLUSTERED

(

[IDPRODUCTO] ASC

)WITH

...