Skip to content

Instantly share code, notes, and snippets.

@hesampour
hesampour / iranStates.sql
Created July 15, 2017 13:07
iran states Names SQL Server
DROP TABLE IF EXISTS [city];
CREATE TABLE city (
[id] int CHECK ([id] > 0) NOT NULL,
[province_id] int CHECK ([province_id] > 0) NOT NULL,
[name] varchar(200) NOT NULL
) ;
INSERT INTO city ([id], [province_id], [name]) VALUES
(1, 1, 'تبريز'),
(2, 1, 'كندوان'),