星空网 > 软件开发 > 数据库

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.

 




原标题:CUBRID学习笔记 30 复制表结构 cubrid教程

关键词:

*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们: admin#shaoqun.com (#换成@)。

数影星球:https://www.goluckyvip.com/tag/41464.html
数字货币:https://www.goluckyvip.com/tag/41466.html
数字金融服务:https://www.goluckyvip.com/tag/41468.html
数字零售:https://www.goluckyvip.com/tag/41469.html
数字贸易:https://www.goluckyvip.com/tag/41470.html
数字媒介:https://www.goluckyvip.com/tag/41471.html
TEMU亚马逊美国站ASTMF3186-17、16CFR1270成人活动床栏安全要求:https://www.kjdsnews.com/a/1836339.html
一线丨访曹县产业带,看中国传统服饰出海如何杀出一个春天?:https://www.kjdsnews.com/a/1836340.html
相关文章
我的浏览记录
最新相关资讯
海外公司注册 | 跨境电商服务平台 | 深圳旅行社 | 东南亚物流