db2 额外添加表字段
ALTER TABLE (TABLE_NAME) ADD COLUMN (COLUMN_NAME) (data_type)
DB2 修改字段的数据类型:
ALTER TABLE (TABLE_NAME) ALTER COLUMN (COLUMN_NAME) SET DATA TYPE (DATA_TYPE)
添加一列并赋默认值:
alter table table_name add column column_name datatype with default default_value
在图形编辑器里reorgtable:
call sysproc.admin_cmd(' reorg table table_name ')
添加或修改字段默认值
ALTER TABLE (TABLE_NAME) ALTER COLUMN (COLUMN_NAME) SET DEFAULT (DEFAULT_VALUE)
修改表结构后需要重新重组一下表:
reorg table (table_name) linux 环境
db2 查看数据库
db2 list db directory
db2 list database directory
db2 进入某个数据库
db2 connect to [database_name]
查看当前数据库的所有的表
list tables
db2 list tables for user
select tabname from syscat.tables where tabschema = current