Cngothic's Blog

Main menu

Skip to primary content
Skip to secondary content
  • Home

Monthly Archives: December 2011

Sql server 创建索引语法

Posted on December 12, 2011 by cngothic
Reply

非聚集

create index 索引名 on 表名(字段名)
--也可以是字段名列表(复合索引)

聚集

create clustered index 索引名 on 表名(字段名)

唯一

create unique index 索引名 on 表名(字段名)
--也可以是字段名列表(复合索引)
Posted in sql server | Tagged clustered index, unique index | Leave a reply

Archives

  • December 2011
  • November 2011
  • September 2011
  • August 2011

Meta

  • Log in
Proudly powered by WordPress