Specifying a Default Value in create table

You can define column defaults using the default clause of the create table statement as an alternative to using create default.

However, these column defaults are specific to that table; you cannot bind them to other tables. See create table and alter table for information about integrity constraints.