创建
0.
CREATE TABLE [dbo].[T_CHARGE_UNIT_TYPE](
[VALUE] [int] NOT NULL CONSTRAINT [PK_T_CHARGE_UNIT_TYPE] PRIMARY KEY,
[TEXT] [nvarchar](50) NOT NULL
)
1.
CREATE TABLE 表名 (字段名1 Int Not Null, 字段名2 nvarchar(13) Not Null 字段名3………… 字段名N…………) GO ALTER TABLE 表名 WITH NOCHECK ADD CONSTRAINT [PK_表名] PRIMARY KEY NONCLUSTERED ( [字段名1], [字段名2] ) GO
2.
ALTER TABLE 表名 ADD CONSTRAINT [新主键名] PRIMARY KEY ([列名])
3.
create table tablename(id int,name char(20),primary key(id,name))
修改
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[主键名]') and OBJECTPROPERTY(object_id(N'[列名]'), N'IsPrimaryKey') = 1)
ALTER TABLE 表名 DROP CONSTRAINT [主键名]
ALTER TABLE 表名 ADD CONSTRAINT [新主键名] PRIMARY KEY ([列名])
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PK_orders]') and OBJECTPROPERTY(OBJECT_ID(N'dbo.[orders].[pi_no]'), N'IsPrimaryKey') = 1)
ALTER TABLE orders DROP CONSTRAINT [PK_orders]
ALTER TABLE orders ADD CONSTRAINT [PK_orders] PRIMARY KEY ([form_no]) ON [PRIMARY]