插入到创建新表 [英] Insert into create new table

问题描述

我有两个大表，并且想要将所有列名(而不是视图)组合到一个新表中.

I have two large tables and want to combine all of the column names (not as a view) into a new table.

我没有权限，右键单击每个表并选择CREATE TO SCRIPT，所以我想知道是否有一种方法可以在不指定列数据类型的情况下将两个表插入到新表中?

I do not have permission to right click on each table and choose CREATE TO SCRIPT, so I was wondering if there is a way to INSERT both Tables into a new table without specifying the column data types?

推荐答案

SELECT top 0 *
INTO NewTable
FROM BigTable1
    CROSS JOIN BigTable2

这篇关于插入到创建新表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！