SQL server 2008 创建主键为自增列的表

最新推荐文章于 2024-09-23 14:11:06 发布

Rachel-Zhang

最新推荐文章于 2024-09-23 14:11:06 发布

阅读量1.9w

点赞数

文章标签： sql server statistics null user table object

本文链接：https://blog.csdn.net/abcjennifer/article/details/5600515

版权

使用Tranact-SQL 编写代码来创建一个新表：

USE [OnlineJudge] GO /****** Object: Table [dbo].[User1] Script Date: 05/17/2010 14:05:06 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[User2](/*notice convert the tablename*/ [num] [int]IDENTITY(1,1) NOT NULL, [userid] [nchar](10) NOT NULL, [password] [nchar](10) NOT NULL, [authority] [int] NOT NULL, [logintime] [datetime] NOT NULL, CONSTRAINT [PK_User2] PRIMARY KEY CLUSTERED /*notice convert the tablename*/ ( [num] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO