0

I have a table T1 that I created in-memory using the in-memory procedure in SQL Server 2016. Now, I want to create a copy of the same table T1 into another table T2 which should have the same schema i.e it should also be in-memory(should be memory optimized).

I know that for creating a copy of a table we use the following query: 

SELECT * INTO T2 FROM T1

But when I use the above query, it creates a blank table T2 which is not in-memory i.e not memory optimized. So, How do I create a copy of an existing in-memory table with the same schema and if possible same data.

Improve this question
3
  • Take a look at the following link, it might be useful. learn.microsoft.com/en-us/sql/relational-databases/… Commented Oct 20, 2018 at 17:21
  • Are you suggesting to use temp table variable? Commented Oct 21, 2018 at 9:55
  • could explain more about the scenario and provide sample code of your tables? Commented Oct 21, 2018 at 16:19
Related questions
5
How do I make a copy of a table within SQL Server Enterprise Manager?
4
SQL Server copy full table definition
1
Can I create an in-memory table in SQL Server 2012?
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.