关于作为选择创建表(CTAS) [英] About create table as select (CTAS)

问题描述

当我们这样做时:

create table big2 as select * from big1;

索引和约束是否也复制到新表中?

Are the indexes and constraints also copied over to the new table?

推荐答案

仅复制NOT NULL约束.请参见常见问题解答.

Only NOT NULL constraints are copied. See FAQ.

您可以执行CREATE TABLE big2 (bigid PRIMARY KEY) AS SELECT * FROM big1 tp创建主键，但是可以，对于其他索引，您需要复制并运行索引创建脚本.

You can do CREATE TABLE big2 (bigid PRIMARY KEY) AS SELECT * FROM big1 tp create a primary key, but yes, for other indexes you'll want to copy and run the index creation scripts.

这篇关于关于作为选择创建表(CTAS)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！