I have several tables with different number of columns, each can be either `real` or `int`, both `not null` (I can define them all real if required).

I would like to write a query that inserts a row with all zeros.

`INSERT [TablesName] DEFAULT VALUES` works good for nullable columns. 

I can't use `INSERT INTO table1 (field1, field2) VALUES (0, 0.0);` as I don't know the number of columns.

Is there a query that would insert a new row with default values for not null tables?