SQLcl to view DDL

Today I ran into a scenario where I need to check if a table had an UNIQUE index.

Instead of writing a quick sql I decided to try the new (not so new) SQLcl tool.  With the new describe (info), I could get a quick snapshot of the table DDL, Indexes and constraints.

Pretty cool.

sqlCl

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s