0

Is there any way I can just say once that the default type should be TEXT, and the default value should be '' for all CREATE TABLEs? Currently I must do:

CREATE TABLE "t" (dbm TEXT DEFAULT '', rsrp TEXT DEFAULT '', cdma TEXT DEFAULT ''...

(I'm using sqlite3.)

Improve this question
2
  • No, as you can see in the documentation. Commented Jan 23, 2022 at 1:08
  • 1
    Note if every column of every table of yours is just the TEXT data type, there's a good chance you're doing something wrong design-wise and should re-evaluate your schema. Commented Jan 23, 2022 at 1:56

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.