cities of Turkey

cities.sql

/*
Source Server         : SqlServer_MesutTalebi
Source Server Version : 105000

Target Server Type    : SQL Server
Target Server Version : 105000
File Encoding         : 65001

Date: 2014-07-17 16:09:37
*/


-- ----------------------------
-- Table structure for [dbo].[City]
-- ----------------------------
DROP TABLE [dbo].[City]
GO
CREATE TABLE [dbo].[City] (
[Id] int NOT NULL ,
[Name] nvarchar(30) NOT NULL 
)


GO

-- ----------------------------
-- Records of City
-- ----------------------------
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'1', N'Adana');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'2', N'Adıyaman');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'3', N'Afyonkarahisar');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'4', N'Ağrı');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'68', N'Aksaray');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'5', N'Amasya');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'6', N'Ankara');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'7', N'Antalya');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'75', N'Ardahan');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'8', N'Artvin');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'9', N'Aydın');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'10', N'Balıkesir');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'74', N'Bartın');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'72', N'Batman');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'69', N'Bayburt');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'11', N'Bilecik');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'12', N'Bingöl');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'13', N'Bitlis');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'14', N'Bolu');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'15', N'Burdur');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'16', N'Bursa');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'17', N'Çanakkale');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'18', N'Çankırı');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'19', N'Çorum');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'20', N'Denizli');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'21', N'Diyarbakır');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'81', N'Düzce');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'22', N'Edirne');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'23', N'Elazığ');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'24', N'Erzincan');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'25', N'Erzurum');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'26', N'Eskişehir');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'27', N'Gaziantep');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'28', N'Giresun');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'29', N'Gümüşhane');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'30', N'Hakkari');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'31', N'Hatay');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'76', N'Iğdır');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'32', N'Isparta');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'34', N'İstanbul');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'35', N'İzmir');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'46', N'Kahramanmaraş');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'78', N'Karabük');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'70', N'Karaman');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'36', N'Kars');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'37', N'Kastamonu');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'38', N'Kayseri');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'71', N'Kırıkkale');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'39', N'Kırklareli');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'40', N'Kırşehir');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'79', N'Kilis');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'41', N'Kocaeli');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'42', N'Konya');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'43', N'Kütahya');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'44', N'Malatya');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'45', N'Manisa');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'47', N'Mardin');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'33', N'Mersin');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'48', N'Muğla');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'49', N'Muş');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'50', N'Nevşehir');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'51', N'Niğde');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'52', N'Ordu');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'80', N'Osmaniye');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'53', N'Rize');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'54', N'Sakarya');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'55', N'Samsun');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'56', N'Siirt');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'57', N'Sinop');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'58', N'Sivas');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'63', N'Şanlıurfa');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'73', N'Şırnak');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'59', N'Tekirdağ');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'60', N'Tokat');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'61', N'Trabzon');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'62', N'Tunceli');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'64', N'Uşak');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'65', N'Van');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'77', N'Yalova');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'66', N'Yozgat');
GO
INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (N'67', N'Zonguldak');
GO

-- ----------------------------
-- Indexes structure for table City
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table [dbo].[City]
-- ----------------------------
ALTER TABLE [dbo].[City] ADD PRIMARY KEY ([Id])
GO

-- ----------------------------
-- Uniques structure for table [dbo].[City]
-- ----------------------------
ALTER TABLE [dbo].[City] ADD UNIQUE ([Name] ASC)
GO