怎样在建好的表中，新建一个字段名？请各位大侠们帮帮忙呢～

[Ariel_sva]

CREATE TABLE [dbo].[oqc_ins_rep] (
[id_ins_rep] [int] IDENTITY (1, 1) NOT NULL ,
[mo_number] [varchar] (25) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,
[key_part_no] [varchar] (25) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,
[kp_name] [varchar] (60) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,
[receive_qty] [numeric](18, 0) NULL ,
[sample_qty] [numeric](18, 0) NULL ,
[pcba_rev] [varchar] (25) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,
[aql] [varchar] (16) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,
[sn_range] [varchar] (80) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,
[carton_range] [varchar] (80) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,
[judgement] [varchar] (16) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,
[other_judge] [varchar] (80) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,
[judgement_by] [varchar] (8) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,
[dt_judgement] [datetime] NULL ,
[dt_issue] [datetime] NULL ,
[test_rev] [varchar] (16) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,
[sop_rev] [varchar] (16) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL
) ON [PRIMARY]
GO
上面是我原先建表的代码

想新增一个字段名
[Repair] [smallint] NULL

请各位大侠帮忙，该用怎样的语句？

[xeqtr1982]

alter table [dbo].[oqc_ins_rep] add [Repair] [smallint] NULL

[liangpei2008]

学习！

[itblog]

alter table [dbo].[oqc_ins_rep] add [Repair] [smallint] NULL

[hb0746]

alter table [ado].[oqc_ins_rep] add [Repair] [smallint] NULL

[liujiayu10]

alter

[jwt1982]

呵呵：说个不同点地
在企业管理器上，数据库--表--设计表--加一个字段OK！

[Ariel_sva]

谢谢楼上各位大侠呢