There are places where Toad formats SQL no matter what, and that drives me nuts. If I don’t choose to format SQL, Toad should leave it alone. Add option: Keep EXEC statements on one line if less than n charactersĪdd option: Always use tabs for indentation and alignment.Select_keywords_alignOption should apply to keywords under INSERT, DELETE, and UPDATE as well as SELECT, or new separate options for those should be addedĪdd checkbox for: Indent of stored procedure body (we don’t use BEGIN/END on our stored procedures, yet everything after the AS is indented by Pretty Printer anyway)Īdd checkbox for: Closing parenthesis on a new line for example:Īdd checkbox for: Remove unnecessary brackets Here are a list of suggestions I sent to the author of SQL Pretty Printer:Ĭommon Table Expression: add Keep AS on same line as WITH checkboxĬommon Table Expression: add parenthesis in a separate line checkbox (like you have for Insert)Ĭommon Table Expression: add Indent checkbox (or number of spaces) to apply to the content between the parenthesisĬreate table: align NULL/NOT NULL just like you currently align data typesĬreate table: add Indent/Align using tabs (for example, data types and NULL/NOT NULL in a CREATE TABLE)ĭeclare: add Align datatype checkbox (like you have in Parameters)Īlign assignment operators in “SELECT Column1 = 0, Column2 = 1” and “DECLARE VARCHAR(10) = ‘test’, INT = 1” I wants some options that even these don’t have, but if Toad could match these I’d feel a lot better about it. To see what could be added, I’d encourage you to look at a free tool like Apex SQL Refactor: Toad offers more formatting options than some of its commercial competitors such as RedGate SQL Prompt or Embarcadero’s Rapid SQL. Kathy, you’ll be shocked to hear that I have some thoughts on this.
0 kommentar(er)
