ALTER TABLE [TABLE명] DROP PRIMARY KEY;
ALTER TABLE [TABLE명] ADD CONSTRAINT [PK명] PRIMARY KEY ([KEY1],[KEY2],[...]); -- PK를 생성한다.
www.techonthenet.com/oracle/primary_keys.php
Oracle / PLSQL: Primary Keys
Oracle / PLSQL: Primary Keys This Oracle tutorial explains how to create, drop, disable, and enable a primary key in Oracle with syntax and examples. What is a primary key in Oracle? In Oracle, a primary key is a single field or combination of fields that
www.techonthenet.com
'기타' 카테고리의 다른 글
| 리눅스 catalina 로그관련 (0) | 2020.06.23 |
|---|
댓글