sqlcode=-193原因解析

最新推荐文章于 2022-11-17 17:36:24 发布

peterkang202

最新推荐文章于 2022-11-17 17:36:24 发布

阅读量3.2k

点赞数

分类专栏：数据库文章标签： sql db2 sqlcode 193

数据库专栏收录该内容

5 篇文章

订阅专栏

当尝试在已存在的表中添加一个定义为NOT NULL的新列时，如果未指定默认值或者指定了NULL作为默认值，则会触发SQL0193N错误。此错误提醒用户需要为该列提供一个非NULL的默认值。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

SQL0193N
In an ALTER TABLE statement, the column column-name has been specified as NOT NULL and    either the DEFAULT clause was not specified or was specified as DEFAULT NULL.

Explanation
When new columns are added to a table that already exists, a value must be assigned to that new column for all existing rows. By default, the null value is assigned. However, since the column has been defined as NOT NULL, a default value other than null must be defined.

User response
Either remove the NOT NULL restriction on the column or provide a default value other than null for the column.

sqlcode: -193

sqlstate: 42601

Parent topic: SQL Messages