You need to sign in to do that
Don't have an account?
PNunes
How to create tables using SQL commands
Hi,
I am creating tables in my salesforce's database through "Schema Builder", but I would like to do using SQL query, to accelerate the process.
Is this possible?
Thanks!
You can use the Metadata API to do this.
There are some tools available on the web also like the link below which uses the Metadata API.
http://wiki.developerforce.com/page/Metadata_Mashup_%E2%80%93_Exporting_MySQL_Schemas_to_Force.com.
There are also some tools on the AppExchange that you can use to do this (DBAmp for example).
All Answers
You can use the Metadata API to do this.
There are some tools available on the web also like the link below which uses the Metadata API.
http://wiki.developerforce.com/page/Metadata_Mashup_%E2%80%93_Exporting_MySQL_Schemas_to_Force.com.
There are also some tools on the AppExchange that you can use to do this (DBAmp for example).
what you can do is
you can create a small .Net application where you write a SQL query & then in .Net we parse the input SQL query & create the appropriate XML & use it with MataData API you can create a table in salesforce
there is no way you can write a SQL query with in salesforce
Thanks Cory and SRK for reply, this is exactly what I need.
Solved.