Running script on SQL database from SQL Developer

Question

I have a SQL database that has a schema on it. I am trying to run a script on this schema from SQL Developer. The problem I'm having is actually doing this from SQL Developer. In the upper right hand corner of the SQL Worksheet screen I can choose the database, but I can't choose the schema. For instance, I need it to run on FLL.dbo. How do I go about doing this?

@gbn I meant SQL Developer but I found out that I needed to use Management Studio. Everything is working now. — Graham
– Graham, Commented Nov 9, 2011 at 23:00

Jimbo · Accepted Answer · 2011-11-08 20:18:44Z

1

scripts target objects within a database

the script itself should identify each object using schemaName.objectname syntax

answered Nov 8, 2011 at 20:18

Jimbo

2,53719 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Running script on SQL database from SQL Developer

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related