http://stackoverflow.com/questions/2626158/multiple-columns-as-primary-keys
ex)
CREATE TABLE Persons
(
P_Id int NOT NULL,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Address varchar(255),
City varchar(255),
CONSTRAINT pk_PersonID PRIMARY KEY (P_Id,LastName)
)'Papers > Database' 카테고리의 다른 글
| sql query example (0) | 2013.08.06 |
|---|---|
| sql query: subselect (0) | 2011.10.25 |
| 강의정리 (0) | 2007.10.10 |
| 첫강의 (0) | 2007.09.16 |