List of countries, cities, languages

You will find in the following links list of countries, cities, and their languages in CSV format, you can import into any database:

Countries:

http://www.ziddu.com/download/1936707/Country.csv.html

Cities:

http://www.ziddu.com/download/1936708/City.csv.html

Languages:

http://www.ziddu.com/download/1936713/Language.csv.html

and the following is the sql script to create these tables in sql server 2005:

USE [World]
GO
/****** Object:  Table [dbo].[City]    Script Date: 08/16/2008 14:48:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[City](
  [ID] [int] NOT NULL,
  [Name] [nvarchar](35) COLLATE Arabic_CI_AS NOT NULL,
  [CountryCode] [nvarchar](3) COLLATE Arabic_CI_AS NOT NULL,
  [District] [nvarchar](20) COLLATE Arabic_CI_AS NULL,
  [Population] [int] NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Country]    Script Date: 08/16/2008 14:48:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Country](
  [Code] [nvarchar](150) COLLATE Arabic_CI_AS NOT NULL,
  [Name] [nvarchar](150) COLLATE Arabic_CI_AS NOT NULL,
  [Continent] [nvarchar](150) COLLATE Arabic_CI_AS NOT NULL,
  [Region] [nvarchar](150) COLLATE Arabic_CI_AS NOT NULL,
  [SurfaceArea] [nvarchar](150) NOT NULL,
  [IndepYear] [nvarchar](150) NULL,
  [Population] [nvarchar](150) NOT NULL,
  [LifeExpectancy] [nvarchar](150) NULL,
  [GNP] [nvarchar](150) NULL,
  [GNPOld] [nvarchar](150) NULL,
  [LocalName] [nvarchar](150) COLLATE Arabic_CI_AS NOT NULL,
  [GovernmentForm] [nvarchar](150) COLLATE Arabic_CI_AS NOT NULL,
  [HeadOfState] [nvarchar](150) COLLATE Arabic_CI_AS NULL,
  [Capital] [nvarchar](150) NULL,
  [Code2] [nvarchar](150) COLLATE Arabic_CI_AS NOT NULL,
CONSTRAINT [PK_Country] PRIMARY KEY CLUSTERED
(
  [Code] 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
/****** Object:  Table [dbo].[Language]    Script Date: 08/16/2008 14:48:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Language](
  [CountryCode] [nvarchar](50) COLLATE Arabic_CI_AS NOT NULL,
  [Language] [nvarchar](50) COLLATE Arabic_CI_AS NOT NULL,
  [IsOfficial] [bit] NULL,
  [Percentage] [nvarchar](50) COLLATE Arabic_CI_AS NULL,
CONSTRAINT [PK_Language] PRIMARY KEY CLUSTERED
(
  [CountryCode] ASC,
  [Language] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]