CREACION DE SCRIPT                       12/09/19
USE [abc]
GO
/****** Object:  Table [dbo].[Municipio]    Script Date: 09/12/2019 10:39:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Municipio](
[IDE municipio] [char](5) NULL,
[Descripcion] [nchar](40) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Estados]    Script Date: 09/12/2019 10:39:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Estados](
[IDE estados] [char](5) NULL,
[Descripcion] [nchar](40) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Domicilio]    Script Date: 09/12/2019 10:39:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Domicilio](
[IDE domicilio] [nchar](10) NULL,
[Calle y numero] [nchar](10) NULL,
[IDE municipio] [nchar](10) NULL,
[IDE estado] [nchar](10) NULL,
[IDE colonia] [nchar](10) NULL,
[Codigo postal] [nchar](10) NULL,
[Localidad] [nchar](10) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Datos generales]    Script Date: 09/12/2019 10:39:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Datos generales](
[id] [nchar](10) NULL,
[Nombre] [nchar](10) NULL,
[Apellido] [nchar](10) NULL,
[Edad] [nchar](10) NULL,
[Sexo] [nchar](10) NULL,
[Profesion] [nchar](10) NULL,
[Cumpleaños] [nchar](10) NULL,
[IDE domicilio] [nchar](10) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[COL]    Script Date: 09/12/2019 10:39:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[COL](
[IDE colonia] [char](5) NULL,
[Descripcion] [nchar](40) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF

GO