SQLEditor Icon

Import and Export with the clipboard

SQLEditor also supports importing and exporting SQL via the clipboard.

If you paste SQL code into an SQLEditor document window then SQLEditor will attempt to parse and import any objects it finds. Errors will appear in the status panel.

If you copy objects out of SQLEditor and then paste into a text application then you will get the code for the objects, normally in the current SQL dialect. If you are using Rails as the default dialect then you will get Rails migration format as the pasted text.

Note that you cannot paste Rails Migrations into SQLEditor.

You should use FileImport From File... instead