ThatJeffSmith

Tag: DDL

Generating Table DDL via SQLcl, with and without Storage Clauses

We’re getting much closer to having Oracle SQL Developer version 4.1 ready for release – which includes SQLcl, our new command-line interface for Oracle Database. Just a quick reminder in case you’re too lazy to click to that other post: We’ve taken our existing Java based SQL*Plus script engine from SQL Developer, and built a […]

Similar Posts by Subject Areas: , , ,

Generating Object DDL Scripts with Drop Statements

Is there a way for SQL Developer to generate a DROP statement when exporting the DDL for a table? Yes. The drop preference will be applied when generating the DDL for scripting purposes, but not for the table editor. So to get the table CREATE DDL script with a DROP TABLE command, right-click on your […]

Similar Posts by Subject Areas: , ,

Adding Columns to a Table in SQL Developer Data Modeler: Honor Column Order?

I have an employees table. Because it’s 1984, HR has decided we need to know Twitter handles, Facebook pages, and who knows what else. So let’s add it to our table. The dialog by default puts new columns at the bottom of the table. We’ll see why in just a moment. On a side note, […]

Similar Posts by Subject Areas: , , , , , ,

Visualize Your DDL Scripts

Data models sure are handy. They tell a story – how does the information get stored as data? Just what is a ‘customer?’ Sometimes though our applications die and only leave legacy scripts behind. Or maybe you are a DBA and someone has given you a set of scripts to create some new objects in […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , , ,