SQL State and Country lists

sql files to make and fill country and state lists with abbreviations

Doesn't get any more straight-forward than that, here is the table structures:
CREATE TABLE dbo.country (
country_id INT NOT NULL PRIMARY KEY IDENTITY,
country_name VARCHAR(50) NOT NULL,
country_abbrev VARCHAR(3) NOT NULL
);

CREATE TABLE dbo.state (
state_id INT NOT NULL PRIMARY KEY IDENTITY,
state_name VARCHAR(50) NOT NULL,
state_abbrev VARCHAR(2) NOT NULL
);



Pingbacks and trackbacks (1)+

Comments are closed