Extract to Separate Script
Introduction
Section titled “Introduction”The Extract to Separate Scriptcreates a new SQL document and extracts the selected code from it.
The Extract to Separate Scriptcommand extracts the selected script into a new SQL document.
To extract the selected code:
-
Select the script that you want to extract.
-
On the SQL Enlight->Refactormenu, click Extract to Separate Script.
-
The Extract to Separate Scriptdialog box is displayed.
The resulting SQL script is displayed in the Previewbox.
-
Modify the order, the type and the direction of the parameters using the Parameters grid.
-
Review the generated script in the Previewbox and modify it if necessary.
-
Click Applybutton to apply the changes.
Parameters
Section titled “Parameters”The parameters of the new objects are determined from the variables which are referenced in the selected code.
SQL Enlightautomatically resolves the data type and the direction of these parameters. If a variable is used but declared nowhere in the script, its declaration in the resulting script will have sql_variantdata type.