Codigo de base de datos
USE [ClaseB]
GO
/****** Objeto: Table [dbo].[Cliente] Fecha de la secuencia de comandos: 03/26/2012 11:26:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SETANSI_PADDING ON
GO
CREATE TABLE [dbo].[Cliente](
[ID] [numeric](10, 0) NOT NULL,
[Nombre] [varchar](20) COLLATE Modern_Spanish_CI_AS NOT NULL,
[A_Paterno] [varchar](15) COLLATE Modern_Spanish_CI_ASNOT NULL,
[A_Materno] [varchar](15) COLLATE Modern_Spanish_CI_AS NULL,
[Direccion] [varchar](50) COLLATE Modern_Spanish_CI_AS NULL,
[Telefono] [varchar](15) COLLATE Modern_Spanish_CI_AS NULL,[Fecha_Nacimiento] [datetime] NULL,
CONSTRAINT [PK_Cliente] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDINGOFF
PRODUCTO
USE [ClaseB]
GO
/****** Objeto: Table [dbo].[Producto] Fecha de la secuencia de comandos: 03/26/2012 11:27:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SETANSI_PADDING ON
GO
CREATE TABLE [dbo].[Producto](
[Codigo] [varchar](10) COLLATE Modern_Spanish_CI_AS NOT NULL,
[Descripcion] [varchar](10) COLLATE Modern_Spanish_CI_AS NULL,
[Precio] [money]NOT NULL,
CONSTRAINT [PK_Producto] PRIMARY KEY CLUSTERED
(
[Codigo] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
PROVEDOORUSE [ClaseB]
GO
/****** Objeto: Table [dbo].[Proveedor] Fecha de la secuencia de comandos: 03/26/2012 11:28:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GOCREATE TABLE [dbo].[Proveedor](
[Ip_P] [numeric](10, 0) NOT NULL,
[Nombre] [varchar](30) COLLATE Modern_Spanish_CI_AS NULL,
[Direccion] [varchar](50) COLLATE Modern_Spanish_CI_AS NULL,
[RFC][varchar](20) COLLATE Modern_Spanish_CI_AS NOT NULL,
CONSTRAINT [PK_Proveedor] PRIMARY KEY CLUSTERED
(
[Ip_P] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]...
Regístrate para leer el documento completo.