how to get create query of msaccess table through c#

[joerozario]

I have the database already with the tables.I want the create query of each table. Is it possible to get the query through c#.or is it possible in msaccess?

[sujithkumarsl]

HI, You can use Msaccess for generating query go to Queries->Create query by using wizard You can select the desirable tables for the queries

My small attempt...

[joerozario]

thank u for u r reply. Actually i have the tables already. your solution gives me the select query for the table but not the "create query". i want create query of the existing table. is it posible to generate (create Query) query as we generate in sql server.

[sujithkumarsl]

I think your question is not clear do you want to create table using query? What you mean by "Create query" ?

My small attempt...

[joerozario]

I have already created the tables.but i need create query of the existing table.

[joerozario]

i have the tables already. i want the create table syntax of the existing table.How can i see? say for example sample is the table that i have created already. now i want the syntax like this create table sample(.....); Where can i go and find this systax in access. If the search i could get the syntax like this only(Select .......) But i want the create table syntax.

[Russell Jones]

i think you need a function called createquerydef() on the access database object. Russ

[joerozario]

createquerydef() how to get this function i didn't get u r idea. can u give more explanation. is function available in MsAcess or available in .net

[V 0]

he means he wants something like "Create table mytable ID int Not null, somevalue varchar2(10), " etc.

V. I found a living worth working for, but haven't found work worth living for.

[Russell Jones]

it's a function that is part of the access runtime library. I belive there is a Primary Interop Assembly available for MS Access so you should be able to use the object from c#. have a look on MSDN for Access PIA and you should find a download. Russ