i can create SQL Database with Xcode ??

If you mean, is there some tool integrated into Xcode that will create a database, then the answer is "not that I know of".

Firstly, there are a number of "SQL" databases - e.g. MySQL - and they don't all have the same "flavour" of the SQL syntax. Sure, the basics are there (depending on which 'standard' they confirm to), but usually you want to create a database that has all of the views, indexes, etc. that are as optimised as possible - and that typically means using the additional keywords of the brand of SQL you are using.

Secondly, I an guessing that you are thinking of the Visual Studio capability of creating an MS-SQL database via the 'GUI' interface they provide.

However, there is nothing to stop you from accessing any type of SQL database from your code. I've quite successfully created and then accessed a MySQL database from code that I've written within Xcode. But you have to do all of the work!!!

If I've not understood your question, then perhaps others will correct me, or you can come back with something more.

Susan

I'm not a database programmer so I have no real knowledge of the pros/cons of various SQL databases, but...

SQLite is installed with Tiger and the CoreData framework can be used in Xcode to interface with SQLite. Xcode provides some interface features for designing elements of your database and Interface Builder allows you to hook interface elements to CoreData features. Here's some general info on using CoreData. And here's a link to the SQLite home page. Typing:

man sqlite3

in Terminal will give you some info on the sqlite3 command line tool.

I could be wrong but my understanding is that SQLite is probably more suited to small scale single-user databases, but I'm really not sure. And I have no idea how well SQLite conforms to standard SQL syntax. But you may want to check this stuff out and see if it would meet your needs.

Steve

You can use the C-Interface routines to pass SQL commands to a Database with X-Code - all of the Database programs have C and Java libraries for that purpose. I test it with PostgreSQL or MySql with good results - since I was using both of them at the time, I am not sure which one I tested it with - may be both.