CUBRID學習筆記 30 複製表結構 cubrid教程

語法

CREATE {TABLE | CLASS} <new_table_name> LIKE <old_table_name>

如下

CREATE TABLE a_tbl(

id INT NOT NULL DEFAULT 0 PRIMARY KEY,

phone VARCHAR(10));

INSERT INTO a_tbl VALUES(1,'111-1111'), (2,'222-2222'), (3, '333-3333');

--creating an empty table with the same schema as a_tbl

CREATE TABLE new_tbl LIKE a_tbl;

SELECT * FROM new_tbl;

There are no results.

;schema a_tbl

=== <Help: Schema of a Class> ===

 <Class Name>

     a_tbl

 <Attributes>

     id                   INTEGER DEFAULT 0 NOT NULL

     phone                CHARACTER VARYING(10)

 <Constraints>

     PRIMARY KEY pk_a_tbl_id ON a_tbl (id)

Current transaction has been committed.

;schema new_tbl

=== <Help: Schema of a Class> ===

 <Class Name>

     new_tbl

 <Attributes>

     id                   INTEGER DEFAULT 0 NOT NULL

     phone                CHARACTER VARYING(10)

 <Constraints>

     PRIMARY KEY pk_new_tbl_id ON new_tbl (id)

Current transaction has been committed.