First, I will create a new relational table. This is accomplished by right clicking on the table parent node. As well, you can create an XML table if you have such a need.
Figure 3: Create New Table
Once you choose New Relational Table, you will be presented with a window such as the following.
Figure 4: Create Relational Table Properties
From this point, you are able to create columns, define the data type, default values, constraints, and indexes, and define the storage properties. In this example, I have established two columns named columnid and fname. As well, I established the columnid column as the primary key. The last thing to do to create this table is to click the Save button. I should also mention that you have the option to preview your SQL.
Now that this basic table is in place, what if you need to modify the existing table or add new columns and triggers, or you simply need to generate the SQL for this table? Once again, it is as easy as right clicking the NEWTABLE node and selecting the function that you need.
Figure 5: Modifying Existing Table
A nice feature that I personally find most useful is being able to generate a script with a single click of the mouse. To add, edit, or delete data, all that is required is to choose Retrieve Data.
As you can gather, it is relatively effortless to create, modify, and delete tables, add triggers, and generate SQL Scripts, all from within the IDE, even if your knowledge of database administration is minimal.
One drawback that I feel could be improved upon is Intellisense. There would be an immense advantage if the functions and procedures from the Oracle database installation were accessible as they are from other commercial products, but for now I must applaud Oracle for its Developer Tools, as it is a much-welcomed addition the Visual Studio .NET IDE for those developers working with an Oracle database.