是的。
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[test]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[test]
GOCREATE TABLE [dbo].[test] (
[a] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[b] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[c] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[d] [char] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GOALTER TABLE [dbo].[test] ADD
CONSTRAINT [PK_test] PRIMARY KEY CLUSTERED
(
[a],
[b]
) ON [PRIMARY]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[test]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[test]
GOCREATE TABLE [dbo].[test] (
[a] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[b] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[c] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[d] [char] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GOALTER TABLE [dbo].[test] ADD
CONSTRAINT [PK_test] PRIMARY KEY CLUSTERED
(
[a],
[b]
) ON [PRIMARY]
GO
解决方案 »
- 如何在select语句中将varchar类型的字段C1转换为int类型?
- SQL排序问题
- 1千万条数据作全文检索,设计问题...
- 一个简单的sql语句求解
- SQL 查询
- 从多张表中查询四个字段,其中遇到难点。。。。求助~~
- Abour Sql server 6.5 table insert
- [求助]windows的administrator密码更改后,SQL登录不能。说用户SA登录失败,怎么解决~?~
- 'SQLOLEDB' 无法启动分布式事务。高分送能人(在线等待)
- 紧急求救:在VC++里如何通过ATL OLE DB访问(INSERT\UPDATE\DELETE\SELECT)ORACLE和SQL SERVER里的BLOB字段内容?
- 弱问一句!请高手指点!
- 很菜的问题,为何在查询分析器里创建的表在控制台根目录不可见?
drop table [dbo].[test]
GOCREATE TABLE [dbo].[test] (
[a] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[b] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[c] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[d] [char] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GOALTER TABLE [dbo].[test] ADD
CONSTRAINT [PK_test] PRIMARY KEY CLUSTERED
(
[a],
[b]
) ON [PRIMARY]
GO或者可以在表的设计模板里面同时选中这三列就可以了