整理一下oracle数据库下关于表与属性的一些操作
1、表的创建
create table Test(
roomNo INTEGER NOT NULL,
hotelNo VARCHAR2(16) NOT NULL,
type VARCHAR2(32) NULL,
price VARCHAR2(32) NULL,
PRIMARY KEY (roomNo,hotelNo),
CONSTRAINTS check_type CHECK(type in ('Single','Double','Family')),
CONSTRAINTS check_roomNo CHECK(roomNo BETWEEN 1 AND 100)
)
2、表的重命名
直接重命名
rename test to room;
间接重命名
create room as