Project Script Files

In an Oracle Database Project Version 2, script file project items represent Oracle SQL scripts. These script files follow the convention of one CREATE statement per SQL file per schema object. Any additional SQL statements beyond a single CREATE statement will be ignored. See the errors and warnings window of Visual Studio and the Visual Studio output window for notifications of this.

When source control is enabled, the Menu Options also contain applicable source control operations.

Menu Options

Menu Item	Description
Open	Edits the item in the Oracle SQL editor.
Open With	Edits the item in the editor that the user selects.
Run	Runs the script using the default database reference. If there is no default database reference, then Run works the same as Run On. The results appear in the Output Pane. If there is a currently running script, then this menu item does not appear.
Run On	Prompts the user for a database reference, then runs the script. The results appear in the Output Pane. If there is a currently running script, then this menu item does not appear.
Cancel	Cancels the currently running script. If there is no script currently running, then this menu item does not appear.
Dependencies and References	Opens the Dependencies and References Viewer for viewing the dependencies that this object has on other database schema objects.
Cut	Copies selected script to the clipboard and prepares the script to be removed after a paste operation.
Copy	Copies the script.
Remove	Deletes the script file. If the script is open in an editor, then you are given the following options: Yes: to close the editor, and delete the script. No: to keep the editor open and not delete the script. If multiple scripts are being deleted, then the operation proceeds to the next script after you select Yes or No. Cancel: to abort the operation. Any scripts that have already been deleted remain deleted.
Rename	Renames the script file
Properties	Displays the properties window

Properties

Property Name	Description
Name	The file name (without path).
File name	The file name including the full path.
Last Modified	The last modified time of the file.