CREATE TABLE KJGL.T_XMSQ_BASE
(
DEPT_ID CHAR(8) NOT NULL,
XMBH CHAR(8) NOT NULL,
SPECIALITY_CODE CHAR(2),
SPECIALITY_STYLE CHAR(2),
NF CHAR(4) CONSTRAINT PK_T_XMSQ_BASE PRIMARY KEY (DEPT_ID, XMBH)
)
(
DEPT_ID CHAR(8) NOT NULL,
XMBH CHAR(8) NOT NULL,
SPECIALITY_CODE CHAR(2),
SPECIALITY_STYLE CHAR(2),
NF CHAR(4) CONSTRAINT PK_T_XMSQ_BASE PRIMARY KEY (DEPT_ID, XMBH)
)
(1)列级别
create table ***
(snum char(9) constraint snum_pk primary key,
...
)
(2)表级别
create table ***
(snum char(9),
...
constraint snum_pk primary key(snum))
alter table ***
ADD constraint snum_pk primary key(snum)&注意:如果主码有一个属性组成,可以在列级别操作;如果主码有多个属性组成(复合主键),必须在表级别操作