I started this post in Qatar waiting for my connection to Hyderabad. My goal is to publish 7 blog posts in 7 days, and share some personal/travel stuff along with the technical content you usually see here.

Today’s article is a short article, around one of our newest features, introduced in version 25.4 (changeLog) of the SQL Developer Extension for VS Code –

We’ve brought you the editor you’ve seen before in SQL Developer and SQL Developer Web.

Tables are JUST the start, next you can expect views and other popular schema objects to appear.

Let’s make a table

There are actually two new interfaces for creating new tables, but for now, ignore the ‘Import Data’ menu item.

Note this opens as a document, not a pop-up modal dialog. This brings many benefits besides just feeling more modern. For starters, I can open multiple of these tasks or switch between them.

To get started, just ‘right click’. If on a table node you will see this:

I simply clicked the ‘+ Add’ button half a dozen times and then filled in the details as required.

Some comments –

• type the column name directly
• reorder columns using the Top/Bottom controls
• ‘check your work’ periodically by going to the DDL page

If you click ‘Apply’, we’ll do the work and display the results in the Output panel. You can do it iteratively, so if you run into problems, you don’t have to start from the beginning.

This is also useful if you are in the Edit dialog for an existing table. Another nice thing about editing tables is that DDL pages can display CREATE and ALTER syntax.