Saturday, September 11, 2010

Using SQL Statements

Switch back to the Java perspective. Create a folder "scripts". Right click on it, select New -> Other and SQL Development and SQL File.

Maintain the folder "scripts" as a target, name the file "myscript.sql" and maintain the connection you have created earlier.

Maintain a SQL statement, e.g. the creation of a Database schema, right click and select "Execute all". After running the script you see the result in the "SQL Results" view.

Switch back to "Database development" perspective, right click on your database and select refresh to see your new schema. You could continue now writing SQL statements to create your database, e.g. creating a table via SQL.

No comments:

Post a Comment

How to Free Up Storage Space on Your Android Phone (Without Deleting Photos)

Running out of space on your Android phone is one of the most common (and most annoying) problems out there - especially once you start gett...