EditPad Pro’s syntax coloring highlights SQL statements, making your SQL files much easier to navigate for your eyes. Several schemes for several SQL dialects are included, each of them in a “full” variant supporting all of the dialect’s features, and a “fast” variant that works well with huge SQL files (up to 2 GB). You can edit the SQL syntax coloring schemes without any restrictions, e.g. to adapt them to a particular SQL dialect you may be working with.
Use EditPad Pro’s built-in FTP and SFTP client to upload your SQL files to your database server right within EditPad Pro. You can even edit database files directly on the server via FTP, without having to download the SQL files to your computer’s hard disk first. EditPad Pro transfers files in the background, so you’ll never have to wait for all files to download, or for a file you’ve saved to finish uploading. You can go on editing right away after saving, and start editing files before they’ve been downloaded completely. EditPad Pro can stay connected to multiple FTP servers.
With EditPad Pro you can easily open and edit many SQL files at the same time. There’s no limit. Arrange SQL files into multiple projects to open them at once and edit them together. Open all files in a folder (and its subfolders) into a project. Many of EditPad Pro’s editing commands can work on all files in a given project at once. Quickly switch between files and projects by clicking on their tabs. Move back and forth with the handy “previous editing position” and “previously edited file” commands. Manage long lists of text files and large projects with the handy file manager sidebar which can rename, move, copy and delete files.
EditPad Pro’s Clip Collection makes it easy to keep a list of SQL snippets at your fingertips, ready to be inserted into any SQL file. Such a snippet can be a single SQL statement, half an SQL database, or anything you want.
EditPad Pro sports one of the most extensive search-and-replace features of any text editor. Quickly find the part of the file you want to edit. Highlight matches, fold lines, and skip over matches and files. Instantly make many replacements throughout a (rectangular) selection, file, project, or all files in all projects. Use regular expressions and adaptive case options for powerful and dynamic search terms and replacements. Clever use of EditPad Pro’s search-and-replace can automate much tedious editing.
Record and play back keystroke macros to reduce repetitive tasks to a single key combination. Record a search as part of a macro to instantly edit all search matches in any particular way. Save any number of macros to build your own library of high-octane text editing wizards. Any menu item or keystroke can be recorded.
Turn on line numbers and column numbers to easily edit line-based and/or column-based data files. Use the go to line command to instantly jump to a particular spot. Set bookmarks to quickly go back to previous spots. EditPad Pro automatically remembers bookmark positions for the last 100 files, and indefinitely in projects.
Use rectangular selections to easily edit columns of text. Any editing command that works on a usual linear selection also works on a rectangular selection. Shift and insert columns left and right, move blocks up and down, fill and indent blocks, etc. Handy commands to begin, end, shrink and expand selections make it easy to work with blocks spanning many pages.
Easily edit all kinds of lists with handy commands to sort lines alphabetically and delete duplicate lines. Use these commands with rectangular selections to sort and trim lists of multiple columns on one of the columns.
If you need to type in some special characters not available on your keyboard, you can use EditPad Pro’s character map to quickly insert them by double-clicking on them. Easily insert special symbols like the trademark or copyright symbol into your SQL documents, or enter letters from a foreign script that your keyboard does not support. If you save your SQL files with a Unicode encoding, you can use any character known to humanity.
EditPad Pro edits all text files. Open text files saved on Linux, UNIX and Macintosh computers, or even text files from old DOS PCs or IBM mainframes. EditPad Pro preserves the file’s compatibility with those systems, unless you explicitly convert it. You’ll never have to worry about being unable to open a text file, and you’ll always be able to save your files in a format that people with less flexible text editors can read. EditPad Pro handles DOS/Windows, UNIX/Linux and Macintosh line breaks. Open and save text files encoded in Unicode (UTF-8, UTF-16 and UTF-32), any Windows code page, any ISO-8859 code page, and a variety of DOS, KOI8 and EBCDIC code pages. Convert files between any of these encodings.