Archives
Trending
Support
Login
clear text
XML
Django
JavaScript
MATLAB
C
C++
C#
Python
SQL
Shell
Bash
Markdown
YAML
JSON
HTML
CSS
PHP
Java
Ruby
Go
Rust
Swift
Kotlin
Arduino
TypeScript
Perl
Autohotkey
Lua
SQF
R
Scala
Haskell
Groovy
Dart
Clojure
VB.NET
Objective-C
PowerShell
Bash
CoffeeScript
Verilog
-- ALTER TABLE ADD TMP_FIELDTOFIX SAMEDATATYPE NEWDEFAULTVALUE [NOT NULL, etc.]; UPDATE RDB$RELATION_FIELDS SET RDB$DEFAULT_VALUE = ( SELECT Q1.RDB$DEFAULT_VALUE FROM RDB$RELATION_FIELDS Q1 WHERE (Q1.RDB$RELATION_NAME = 'TABLENAME') AND (Q1.RDB$FIELD_NAME = 'TMP_FIELDTOFIX') ), RDB$DEFAULT_SOURCE = ( SELECT Q2.RDB$DEFAULT_SOURCE FROM RDB$RELATION_FIELDS Q2 WHERE (Q2.RDB$RELATION_NAME = 'TABLENAME') AND (Q2.RDB$FIELD_NAME = 'TMP_FIELDTOFIX') ) WHERE (RDB$RELATION_NAME = 'TABLENAME') AND (RDB$FIELD_NAME = 'FIELDTOFIX') ; -- ALTER TABLE DROP TMP_FIELDTOFIX;
Mark as private (unlisted)
for 30 minutes
for 6 hours
for 1 day
for 1 week
for 1 month
for 1 year
everlasting (like CCCP)
