In T-SQL, how to insert a new row with all values set by default?

Question

Hi,

In Microsoft SQL database, I have a table where every column have default values (either fixed values or stuff like identity or getdate()).

I am trying to write an SQL statement which will insert a new row in which every cell will have a default value.

Neither

insert into MySchema.MyTable

nor

insert into MySchema.MyTable () values ()

are valid syntax.

So is it possible to insert a new row without specifying any value?

Answer 1

insert into foo DEFAULT VALUES