How to set a default value created by the user in the creation of a table (SQL Server)?

Question

I created a default value for my database:

CREATE DEFAULT [dbo].[zero] as 0

But I cannot create a table using this default value created. How do I set this value when creating a table? For example:

CREATE TABLE TESTE ( num int DEFAULT zero)

Answer 1

You can set the value default field "num" when creating the TEST table like this:

CREATE TABLE TESTE
(
    num int DEFAULT (0)
)

This "CREATE DEFAULT" feature will be removed in a future version of Microsoft SQL Server in accordance with msdn, then it’s good to avoid it.