I have several tables with different number of columns, each can be either
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?