CODEWITHSUNDEEP
vb.net
Harish
Harish

Reputation: 169

vb.net query for creating table

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 ?

Upvotes: 0

Views: 1320

Answers (2)

ananth_adroit
ananth_adroit

Reputation: 347

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

Upvotes: 0

Guffa
Guffa

Reputation: 700840

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).

Upvotes: 1

Related Questions