We would like to modify the SQL for "CREATE TABLE" sql queries.

The idea is to add "WITH (MEMORY_OPTIMIZED=ON, DURABILITY=SCHEMA_ONLY)"

Is it possible to customize "CREATE TABLE" queries?

asked Mar 16 '18 at 10:23

olorin's gravatar image

olorin
358878792


One Answer:

Hello olorin,

It won't work. There are more things you will have to do for memory-optimized tables. You cannot only create such tables, because if such tables are treated as regular tables (disk-based tables) queries will fail - schema upgrade queries and some data modification queries. For proper work such tables should be handled as memory-optimized by DataObjects.Net.

We are working on such tables support now. We will introduce it in one of our further Betas soon.

answered Mar 22 '18 at 02:39

Alexey%20Kulakov's gravatar image

Alexey Kulakov
77225

That's interesting. For information, we want to use this option for tests : we already create a database from scratch for tests, so schema upgrade is not an issue.

I'm interested for the beta when it's ready.

(Mar 22 '18 at 03:49) olorin olorin's gravatar image
Your answer
Please start posting your answer anonymously - your answer will be saved within the current session and published after you log in or create a new account. Please try to give a substantial answer, for discussions, please use comments and please do remember to vote (after you log in)!
toggle preview

powered by OSQA