CODEWITHSUNDEEP
oracle-databaseoracle11goracle-sqldeveloper
user13942420
user13942420

Reputation:

Oracle SQL Developers: "script table as" function

I am working on a database and my task is to enter the logic.

What I need to know is: is it possible, with ORACLE SQL DEVELOPER, using the function "script table as" ?

With SQL Server, for example, I can right click on the table, click on "script table as" and get the script with all of the information (FK, contraints, ecc...).

The table is named "STRUTTURE" and is part of the user schema "SAO".

So the "full name" is "SAO.STRUTTURE".

I found out a command like this online:

set long 50000
/
select dbms_metadata.get_ddl( ‘TABLE’, ‘EMP’, ‘SCOTT’ ) from dual

but does not work.

Any one can help me?

Thank you very much in advance!

Upvotes: 0

Views: 184

Answers (1)

Littlefoot
Littlefoot

Reputation: 143103

When you select a table, on the right hand side you see information related to it (displayed as tabs):

  • columns
  • data
  • ...
  • SQL --> that's the one you're looking for

You didn't mention which SQL Developer version you use; maybe you'll have to upgrade (it is free) if your version doesn't have that tab.

Upvotes: 4

Related Questions