Create Table

CREATE TABLE SchemaName.TableName (
	TableNameId INT IDENTITY(1, 1), -- go for a bigger value than an int if more than 1b
	TypeOfThing VARCHAR(50) NULL, -- can be null
	Name        VARCHAR(50) NOT NULL, -- cannot be null
	Price       DECIMAL(18, 2) NULL DEFAULT(10.02), -- when price is not set, it will be 10.02
	Quantity    INT,
	ReleaseDate DATE,
	CreateDate  DATETIME,
	UpdateDate  DATETIME
)

Note: that Default is only triggered when a value is NULL

IDENTITY(10,2) - start at 10 (seed number), increment by 2