aaaa


Comandos para crear toda la base de datos
Créate database DB
Go
USE [DB]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create TABLE [dbo].[producto](
[id_articulo] [bigint] NOTNULL,
[nombre] [nvarchar](20) NOT NULL,
[descripcion] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_producto] PRIMARY KEY CLUSTERED
(
[id_articulo] ASC
)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE[dbo].[direccion](
[id_direccion] [int] NOT NULL,
[numero] [int] NOT NULL,
[calle] [nvarchar](20) NOT NULL,
[colonia] [nvarchar](20) NOT NULL,
[ciudad] [nvarchar](20) NOT NULL,
CONSTRAINT [PK_direccion]PRIMARY KEY CLUSTERED
(
[id_direccion] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[fabricas](
[id_fabrica] [int] NOT NULL,
[nombre] [nchar](20) NOT NULL,
[id_articulo][bigint] NOT NULL,
[existencias] [int] NOT NULL,
[telefono] [varchar](10) NOT NULL,
CONSTRAINT [PK_fabricas] PRIMARY KEY CLUSTERED
(
[id_fabrica] ASC
)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GOCREATE TABLE [dbo].[direcciones](
[id_direcciones] [int] NOT NULL,
[dir1] [int] NOT NULL,
[dir2] [int] NULL,
[dir3] [int] NULL,
[dir4] [int] NULL,
CONSTRAINT [PK_direcciones] PRIMARY KEYCLUSTERED
(
[id_direcciones] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO...