Customize create table SQL

0	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? dataobjects.net sql create asked Mar 16 '18 at 10:23 olorin 358●87●87●92

One Answer:

oldest newest most voted

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 Kulakov
772●2●5

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

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

community wiki

Subscription:

Once you sign in you will be able to subscribe for any updates here

Tags:

DataObjects.Net ×574
sql ×31
create ×2

Asked: Mar 16 '18 at 10:23

Seen: 2,385 times

Last updated: Mar 22 '18 at 03:49

Subscription:

Related questions