아래의 사이트에서 일부 발췌하였습니다.
<a href="http://winapi.co.kr/toollec/SQL/SQL.htm">http://winapi.co.kr/toollec/SQL/SQL.htm</a>
CREATE DATABASE database_name
[ ON
[ PRIMARY ] [ <filespec> [ ,...n ]
[ , <filegroup> [ ,...n ] ]
[ LOG ON { <filespec> [ ,...n ] } ]
]
[ COLLATE collation_name ]
[ WITH <external_access_option> ]
]
[;]
<filespec> ::=
{
(
NAME = logical_file_name ,
FILENAME = 'os_file_name'
[ , SIZE = size [ KB | MB | GB | TB ] ]
[ , MAXSIZE = { max_size [ KB | MB | GB | TB ] | UNLIMITED } ]
[ , FILEGROWTH = growth_increment [ KB | MB | GB | TB | % ] ]
) [ ,...n ]
}
CREATE TABLE tblCountry
(
Name NVARCHAR(30) NOT NULL PRIMARY KEY,
Capital NVARCHAR(30) NULL ,
Popu INT NULL ,
Cont NCHAR(2) NULL CHECK (Cont IN ('AS', 'SA', 'NA', 'EU', 'AF', 'AU')),
Area INT NULL
);
CREATE TABLE tblSales
(
OrderNo INT IDENTITY(1,1) PRIMARY KEY NOT NULL,
Date DATETIME NULL,
Customer NCHAR(10) NULL,
Item NCHAR(30) NULL
);
INSERT INTO tblSales (Date, Customer, Item) VALUES ('2008/5/1','전두환','모자');
INSERT INTO tblSales (Date, Customer, Item) VALUES ('2008/5/1','김영삼','라면');
INSERT INTO tblSales (Date, Customer, Item) VALUES ('2008/5/2','김대중','지팡이');
INSERT INTO tblSales (Date, Customer, Item) VALUES ('2008/5/3','노무현','라면');
INSERT INTO tblSales (Date, Customer, Item) VALUES ('2008/5/8','김영삼','노트북');
INSERT INTO tblSales (Date, Customer, Item) VALUES ('2008/5/8','박정희','볼펜');</filespec></external_access_option></filespec></filegroup></filespec>
CREATE TABLE tblFresher
(
Name NCHAR(10) PRIMARY KEY NOT NULL,
Weight INT NULL,
Height INT NULL,
Age INT NOT NULL DEFAULT (16),
Psycho NCHAR(20) NOT NULL DEFAULT (N'이상없음')
);
INSERT INTO tblFresher (Name, Weight, Height) VALUES ('김상형',69,180)
----------------------------------------------------------------
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tblCountry](
[Name] [nvarchar](30) COLLATE Korean_Wansung_CI_AS NOT NULL,
[Sudo] [nvarchar](30) COLLATE Korean_Wansung_CI_AS NULL,
[Popu] [int] NULL,
[Cont] [int] NULL,
[Area] [int] NULL,
PRIMARY KEY CLUSTERED
(
[Name] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
우리가 직접 작성한 스크립트
