SELECT INTO query to create MEMORY_OPTIMIZED table

Question

is it possible to generate a MEMORY_OPTIMIZED table with an SELECT INTO statement? Something like:

SELECT *
INTO MemoryOptimizedTargetTable
FROM SourceTable;

Or at least convert the target after the SELECT INTO with an ALTER statement?

Thanks

Remus Rusanu · Accepted Answer · 2017-06-07 07:38:59Z

1

No.

With SQL Server 2017 it will be possible to specify a filegroup, but that's as far as it goes into customizing the created table.

Since SELECT ... INTO ... is equivalent to CREATE TABLE, to be fully customizable it would require all options CREATE TABLE has. This is not really feasible. Once you realizE that in effect you are creating a table and inserting rows into it, why not do just that?

CREATE TABLE ...
INSERT ... SELECT ...

answered Jun 7, 2017 at 7:38

Remus Rusanu

296k42 gold badges459 silver badges583 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SELECT INTO query to create MEMORY_OPTIMIZED table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related