如何检查主键isidentity属性为是或否 [英] how check primary key isidentity properties is yes or no

问题描述

您好，先生，我发现主键是使用查询的主键名称中的isident或no中的isidentity，请给我解决方案.

Hello sir i find primary key is isidentity in yes or no from primary key name using query please give me solution.

推荐答案

请参见下面的链接:

let see the link below:
http://stackoverflow.com/questions/222217/how-do-i-determine-if-a-column-is-in-the-primary-key-of-its-table-sql-server[^]

您可以将其转换为过程以将PK名称传递给它.

You can convert this to procedure to pass PK name to it.

Declare @Table varchar(50)
Declare @Column varchar(50)

SELECT @Column=Column_Name, @Table=KU.Table_Name
FROM  INFORMATION_SCHEMA.TABLE_CONSTRAINTS AS TC
INNER JOIN
INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS KU
ON TC.CONSTRAINT_TYPE = 'PRIMARY KEY' AND
TC.CONSTRAINT_NAME = KU.CONSTRAINT_NAME
Where KU.Constraint_Name = 'PK_Books_1' -- specify your key/pass it as parameter

SELECT	is_identity
FROM	sys.columns
WHERE	[object_id] = object_id(@Table) and name = @Column

这篇关于如何检查主键isidentity属性为是或否的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！