Creating in-memory tables

- Okay, let's take a look at creating…a memory-optimized table.…So we're going to let SQL help us…and I'm in Manager Studio…in Object Explorer.…I'm going to right-click Table, New,…Memory Optimized Table,…and let me change this display a little bit.…So here's a little comments in there…and we're going to take the code and get rid…of what we're not going to do.…We're not going to create file groups,…and you can put Memory Optimized Tables…into Memory Optimized file groups,…and I'm just going to select all this and dump it out…so we can concentrate on the code…that we want to see.…

Now we're going to create a table,…this is the same code that we looked…at in the slot, schema name,…sysname, dbo,…by default or whatever schema we're putting it into.…Then the table name,…and then they give me a sample…Memorized Optimized Table, fine.…Here's my columns, primary key first,…datatype Not Null and then another column,…and another column and of course,…the more columns you want, you would…just copy and paste this code,…moving it on down.…