mytest_country_create.sql
/*==============================================
* *
* create table country *
* *
==============================================*/
USE mytest; -- you must have created the database mytest
IF OBJECT_ID ('country', 'U') IS NOT NULL
BEGIN
PRINT 'The table country already exists. Delete it.'
RETURN
END
-- =========== create table country ===========
-- create table country
CREATE TABLE country (
cid INT NOT NULL PRIMARY KEY,
name VARCHAR(20) NOT NULL
)