Search Results for "trigger"

...The SQL Editor window assists users with SQL syntax hints & highlighting, provides pretty-print code formatter, and marks syntax errors. You can Ctrl+click on the table mentioned in the SQL query to open that table (or index, or trigger, or view). Currently supported encrypted, password-protected SQLite variations are SQLCipher, WxSQLite3, and System.Data.SQLite. You can execute SQL statements that refer to multiple databases within a single query, thanks to a transparent database attaching mechanism built into the SQL Editor of SQLiteStudio. You can implement your own SQL functions (scalar & aggregate) using JavaScript, Python, or Tcl. ...

Firebird RDBMS offers ANSI SQL features & runs on Linux, Windows & several Unix platforms. Features excellent concurrency & performance & powerful stored procedure & trigger language. More information and downloads at https://firebirdsql.org/, issue tracker is https://github.com/FirebirdSQL/firebird/issues

...Scheduled backup (to remote server or to file). 2. Add a DROP DATABASE statement before each CREATE DATABASE statement 3. Add a DROP TABLE statement before each CREATE TABLE statement 4. Add a DROP TRIGGER statement before each CREATE TRIGGER statement 5. Surround each table dump with LOCK TABLES and UNLOCK TABLES statements 6. Dump all tables in all databases 7. Allow creation of column names that are keywords 8. Add comments to the dump file 9. Produce more compact output 10. Use complete INSERT statements that include column names 11. ...