CREATE TABLE [dbo].[Ciudades] (
    [IdCiudad]   INT          IDENTITY (1, 1) NOT NULL,
    [IdPais]     INT          NULL,
    [Nombre]     VARCHAR (30) NULL,
    [CodigoDane] VARCHAR (30) NULL,    
    CONSTRAINT [PK_Ciudades] PRIMARY KEY ([IdCiudad]), 
    CONSTRAINT [FK_Ciudades_Paises] FOREIGN KEY ([IdPais]) REFERENCES [Paises]([IdPais])
);

