building.sql

来自「Visual Basic + Oracle 9i数据库应用系统开发与实例《小区物」· SQL 代码 · 共 10 行

CREATE TABLE HSEMAN.Building
(
  BuildingId 	Smallint PRIMARY KEY,
  BuildingNo	Varchar2(20) NOT NULL,
  FloorNum	Smallint DEFAULT 0,
  Memo	VARCHAR2(300)
)
TABLESPACE USERS;