ALTER TABLE Tab ADD TimeIns TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL #3946
Unanswered
rene-weiss
asked this question in
Q&A
Replies: 2 comments
-
This is how SQLite3 database works and it's intentional. See point |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Details
Change Table ALTER will not work... Error:
--> Cannot add a column with non-constant default
Steps to reproduce
this works...:
CREATE TABLE my_table (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
name VARCHAR(64),
sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL
)
This not:
ALTER TABLE tabTmx ADD TimeIns TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL
Operating system
Win10
SQLiteStudio version
3.2.1
Beta Was this translation helpful? Give feedback.
All reactions