| Question | Answer |
|---|---|
| How do I copy both headers and data from results? | Select the data, press Ctrl+Shift+C, then click OK |
| How can I get all rows of data from a query? | DBeaver limits results to 2k rows by default. Right-click the results and select Read All Rows or change the limit in settings |
| How do I duplicate a connection? | Right-click the existing connection and choose Copy/Paste |
| How do I run multiple DDL/DML statements? | Use Execute SQL Script instead of Execute SQL Query |
| How do I change the date format in results? | Teradata defaults to YYYY-MM-DD. To change formats, follow DBeaver’s Managing Data Formats guide |
| How can I run parameterized SQL queries (prompted SQL)? | Go to Editors → SQL Editor → SQL Processing, then enable:• Anonymous SQL parameters • Enable parameters in DDL and $$..$$ blocks Example: SELECT * FROM my_table WHERE column = :PARAM; |
| How do I rename a connection? | Right-click the connection and choose Rename |