New lines automatically indent to the previous line start column.Įxecuting a SQL Script from the SQL Scripts Page Use standard edit controls to cut, copy and paste content in the Script Editor.Īuto indenting lines. Click the line number on the left side of the Script Editor to select the associated line of your script for copying or deleting.Ĭutting and Pasting. Click Find to display the text and JavaScript regular expression find and replace options. Click Undo (Ctrl+Z) and Redo (Ctrl+Y) to undo or redo line edits in the Script Editor. Click Run to submit the script for execution. The SQL Scripts page appears.Įxecute the script. Click Save to save your changes to the script to the Script Repository. Save the script to the Script Repository. Click Delete to remove the current script from the Script Repository. Enter a name for the script on your local file system and a directory path.ĭelete the script from the Script Repository.
#Sqlitestudio execute .sql script download
Click Download to save a copy of the current script to your local file system. Save the script to your local file system. Click Cancel to exit the Script Editor without saving changes made since you last saved. You can perform the following actions in the Script Editor:Ĭancel the editing session. See "Executing a SQL Script", and "Viewing SQL Script Results".Ĭlick Save to save your script to the Script Repository, The Run Script dialog and the Script Results pages enable you to resume editing the script. You can test your script during editing by running the script to reveal errors. You can load a script into the editor as follows:ĭescription of the illustration script_editor.gifĮdit the script. On the Database Home Page, click the SQL icon. You use the Script Editor to add content to a new script, to edit existing scripts, and to run and delete scripts in the script repository. See "Exporting and Importing SQL Scripts".
The export script to import must be accessible on your local file system. Import only imports scripts encoded in an export script created using Export. Upload enables you to import a script exported by this, or a different workspace.
The export script is named workspace_name_script.sql by default. The scripts you select to export are encoded in a single export script written to your local file system. It also shows the maximum size of a SQL Script.Įxport enables you to export multiple scripts from the current SQL Script Repository for import into SQL Scripts in a different database user account. The Script Quotas page shows the maximum size of a single result, the maximum size of all results, the quota used and the quota free. Show Quotas displays the Script Quotas page. Manage Results enables you to view, search, and display results. The Task list contains the following links: See "Creating a SQL Script".Ī Tasks list displays on the right side of the SQL Scripts page.ĭescription of the illustration script_tasks.gif Click Create to create a new script in the Script Editor. Click Upload to upload a script from your local file system into SQL Scripts. In Details view, click a column heading to sort the listed scripts by that column. In Details view, select the check box associated with the script you want to delete and click Delete Checked. Each line includes a check box to enable the selection of scripts for deletion, an edit icon to enable the script to be loaded into the script editor, the script name, the script owner, when the script was last updated and by who, the size in bytes, the number of times the script has been run linked to the run results, and an icon to enable the script to be run.ĭetails view offers the following additional controls:ĭelete Checked. Click the Show Results check box to additionally display run results as icons identified by the script name.ĭetails displays each script as a line in a report. Icons (default) displays each script as an icon identified by the script name. Change the appearance of the SQL Scripts page by making a selection from the View list and clicking Go. Search for the owner of the script you want to view by entering the username in the Owner field and clicking Go. You control how many rows display by making a selection from the Display list. Search for a script by entering the script name, or a partial name, in the Script field and clicking Go. The SQL Scripts page features the following controls: Details view displays each script as a row in a report.ĭescription of the illustration script_home.gif The default view, Icons, displays each script as an icon. You can control the appearance of the page by making a selection from the View list. The SQL Scripts page display all SQL scripts created by the current user.
0 kommentar(er)
