function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
PNunesPNunes 

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!

Best Answer chosen by Admin (Salesforce Developers) 
Cory CowgillCory Cowgill

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

Cory CowgillCory Cowgill

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

 

 

 

 

This was selected as the best answer
SRKSRK
As mention by Cory Cowgill you need to use Metadata API

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
PNunesPNunes

Thanks Cory and SRK for reply, this is exactly what I need.

 

Solved.