Обсуждение: adding not null constraints on columns

Поиск
Список
Период
Сортировка

adding not null constraints on columns

От
"Susan"
Дата:
Is there a way to add not null constraints on a column after the column has been created?  Any help would be appreciated.  Thanks.
 
The most likely way for the world to be destroyed, most experts agree, is by accident. That's where we come in; we're computer professionals. We cause accidents.
Nathaniel Borenstein (1957 - )
 
 
Вложения

Re: adding not null constraints on columns

От
Tom Lane
Дата:
"Susan" <brknrose@counterconspiracy.org> writes:
> Is there a way to add not null constraints on a column after the column
> has been created?  Any help would be appreciated.  Thanks.

Certainly.  See the ALTER TABLE command.
        regards, tom lane

Чтобы сделать работу с сайтом удобнее, мы используем cookie и аналитический сервис «Яндекс.Метрика». Продолжая пользоваться сайтом, вы соглашаетесь с их использованием.