使用身份关键字查询主键约束 [英] Queryfor primary key constraint with identity key word

问题描述

用身份关键字写查询主键约束吗?
在我的一次采访中有人问过..plz让我知道答案

Write a query for primary key constraint with identity key word?
It was asked in one of my interviews..plz let me know the answer

推荐答案

CREATE TABLE [dbo].[Tbl1]
(
    [Id] [bigint] IDENTITY(1,1) NOT NULL,
     CONSTRAINT [PK_Tbl1] PRIMARY KEY CLUSTERED
     (
       [Id] 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

此处:

CREATE TABLE [dbo].[TestTable]
(
   ID int IDENTITY(1,1)   NOT NULL,
   FirstName varchar(100) NULL,
   CONSTRAINT [PK_TestTable] PRIMARY KEY CLUSTERED([ID] ASC)
)

或

OR

CREATE TABLE CUSTOMERS(
       ID  INT IDENTITY(1,1) NOT NULL,
       NAME VARCHAR (20)     NOT NULL,
       AGE  INT              NOT NULL,
       ADDRESS  CHAR (25) ,
       SALARY   DECIMAL (18, 2),       
       PRIMARY KEY (ID)
);

参考:
SQL-主键 [ MSDN:创建表(Transact-SQL) [ ^ ]

Refer:
SQL - Primary Key[^]
MSDN: CREATE TABLE (Transact-SQL)[^]

尝试一下:

Try this:

CREATE TABLE Demo( DemoId int identity (1,1) Primary key, UserID int, Name nvarchar(100))

另请参阅:
sql-创建 [

Also refer:
sql - create[^]

这篇关于使用身份关键字查询主键约束的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！