Clone MySql table structure in C#

Question

I'm using MySQL.Data 6.9.9 library and .Net framework 4.5 to work with MySQL server in C# code.

There is a table1 with rows and I want to create the table2 with the same structure as table1 in same database but without rows.

Please advice how to create it?

What have you tried already? Can't you just use a query to create the table? — Foitn, Apr 20 '18 at 13:37

Raymond Nijland · Accepted Answer · 2018-04-21T15:38:57.313

4

MySQL can do that out of the box.

CREATE TABLE
 table
LIKE 
 table

Use CREATE TABLE ... LIKE to create an empty table based on the definition of another table, including any column attributes and indexes defined in the original table:

source https://dev.mysql.com/doc/refman/8.0/en/create-table-like.html

edited Apr 21 '18 at 15:38

answered Apr 20 '18 at 13:40

Raymond Nijland

11,488
2
22
34

1

@borobos Mark it as the solution if this the answer. – Emy Blacksmith Apr 20 '18 at 13:45

score 0 · Answer 2 · answered Apr 20 '18 at 13:48

0

You can do it manually:

CREATE TABLE table2  LIKE table1;

And then update your edmx model if you use "Database First" approach.

answered Apr 20 '18 at 13:48

Dmytro Tysko

63
6

Thanks, I'm not use "Database First" approach but the usage of MySqlCommand with this create syntax is that what I needed. Also, found the related https://stackoverflow.com/a/20320118/2679054 – borobos Apr 20 '18 at 14:02

Clone MySql table structure in C#

2 Answers2