vb.net query for creating table

Question

I have Access as my back end. Student is the database name and its path is c:\Project\student.mdb

And am having few tables in it. When i click a command button in vb.net a new table must be created in the path mentioned. And it should have the fields I declare.

What s the query I need to use ? Is it possible to do like that ?

Guffa · Accepted Answer · 2010-11-09 17:19:52Z

1

Yes, it's possible, you can check out the syntax for the create table command.

However, I have to say that creating tables dynamically suggests a bad database design. The database layout should normally remain the same whatever data you put in the database.

If you create tables dynamically, that means that you have data in the table names, but data should go inside the tables, not in table names (or even field names).

answered Nov 9, 2010 at 17:19

Guffa

703k111 gold badges760 silver badges1k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ananth_adroit · Accepted Answer · 2011-07-20 17:05:40Z

0

Yes it's possible . Just pass the create table command as query and the table name as variable , which you want to add dynamically. for reference of create table command

Create table command

answered Jul 20, 2011 at 17:05

ananth_adroit

3471 gold badge5 silver badges19 bronze badges

Collectives™ on Stack Overflow

vb.net query for creating table

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related