--建新表
CREATE TABLE [dbo].[t_register] (
[fguid] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[fkey] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[fvalue] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
[zindex] [int] NULL ,
[fset] [int] NULL
) ON [PRIMARY]
GO
--设置主键
ALTER TABLE [dbo].[t_register] WITH NOCHECK ADD
CONSTRAINT [PK_t_register] PRIMARY KEY CLUSTERED
(
[fguid]
) ON [PRIMARY]
GO
--删除旧表
drop table [dbo].[t_reg_table]
GO