看看SQL语句吧!ALTER TABLE [dbo].[D_DETAIL_SORTLX] WITH NOCHECK ADD
CONSTRAINT [PK_D_DETAIL_SORTLX] PRIMARY KEY CLUSTERED
(
[ID_NO]
) ON [PRIMARY]
GO
CONSTRAINT [PK_D_DETAIL_SORTLX] PRIMARY KEY CLUSTERED
(
[ID_NO]
) ON [PRIMARY]
GO
alter table db_pdyk add send [char] (1) null
用FIELDS.ADD就可以了。如果不行,请和我联系,我可以发一个例子给你。
[email protected]
alter table DH_SM_CURE add detail_dcl [char] (1) null
alter table db_pdyk add send [char] (1) null
ALTER TABLE ADD COLUMN NAME TEXT(10)
SQL SERVER 加字段是这样写的:
ALTER TABLE ADD NAME VARCHAR(10)
ALTER TABLE TABLENAME ADD COLUMN NAME TEXT(10)
SQL SERVER 加字段是这样写的:
ALTER TABLE TABLENAME ADD NAME VARCHAR(10)
ALTER TABLE TABLENAME ADD COLUMN NAME TEXT(10)
SQL SERVER 加字段是这样写的:
ALTER TABLE TABLENAME ADD NAME VARCHAR(10)