blocks|key|3016848|text|我找到了另一个：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3016849|SELECT+
+++++KU.table_name+as+TABLENAME
++++,column_name+as+PRIMARYKEYCOLUMN
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+
++++AND+KU.table_name='YourTableName'

ORDER+BY+
+++++KU.TABLE_NAME
++++,KU.ORDINAL_POSITION
;+|code-block|syntax|javascript|3016850|我已经在SQL+Server+2003/2005上对此进行了测试|3016851|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Found another one:
<pre><code>SELECT 
 KU.table_name as TABLENAME
 ,column_name as PRIMARYKEYCOLUMN
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 
 AND KU.table_name='YourTableName'

ORDER BY 
 KU.TABLE_NAME
 ,KU.ORDINAL_POSITION
; 
</code></pre>
I have tested this on SQL Server 2003/2005

blocks|key|3016779|text|我还为SQL+Server找到了另一个：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3016780|SELECT+COLUMN_NAME
FROM+INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE+OBJECTPROPERTY(OBJECT_ID(CONSTRAINT_SCHEMA+%2B+'.'+%2B+QUOTENAME(CONSTRAINT_NAME)),+'IsPrimaryKey')+=+1
AND+TABLE_NAME+=+'TableName'+AND+TABLE_SCHEMA+=+'Schema'|code-block|syntax|javascript|3016781|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I also found another one for SQL Server:

<pre><code>SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE OBJECTPROPERTY(OBJECT_ID(CONSTRAINT_SCHEMA + '.' + QUOTENAME(CONSTRAINT_NAME)), 'IsPrimaryKey') = 1
AND TABLE_NAME = 'TableName' AND TABLE_SCHEMA = 'Schema'
</code></pre>

blocks|key|3016718|text|使用SQL+SERVER+2005，您可以尝试|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3016719|SELECT++i.name+AS+IndexName,
++++++++OBJECT_NAME(ic.OBJECT_ID)+AS+TableName,
++++++++COL_NAME(ic.OBJECT_ID,ic.column_id)+AS+ColumnName
FROM++++sys.indexes+AS+i+INNER+JOIN+
++++++++sys.index_columns+AS+ic+ON++i.OBJECT_ID+=+ic.OBJECT_ID
++++++++++++++++++++++++++++++++AND+i.index_id+=+ic.index_id
WHERE+++i.is_primary_key+=+1|code-block|syntax|javascript|3016720|可在SQL+SERVER+–+2005+–+Find+Tables+With+Primary+Key+Constraint+in+Database找到|offset|length|3016721|entityMap|0|LINK|mutability|MUTABLE|url|http://blog.sqlauthority.com/2007/09/04/sql-server-2005-find-tables-with-primary-key-constraint-in-database/^0|0|0|2|1Z|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@$I|V|J|W|1|X]]|A|$]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R]]]]

Using SQL SERVER 2005, you can try

<pre><code>SELECT i.name AS IndexName,
 OBJECT_NAME(ic.OBJECT_ID) AS TableName,
 COL_NAME(ic.OBJECT_ID,ic.column_id) AS ColumnName
FROM sys.indexes AS i INNER JOIN 
 sys.index_columns AS ic ON i.OBJECT_ID = ic.OBJECT_ID
 AND i.index_id = ic.index_id
WHERE i.is_primary_key = 1
</code></pre>

Found at <a href="http://blog.sqlauthority.com/2007/09/04/sql-server-2005-find-tables-with-primary-key-constraint-in-database/" rel="noreferrer">SQL SERVER – 2005 – Find Tables With Primary Key Constraint in Database</a>

blocks|key|296674|text|从记忆中看，要么是这个|type|unstyled|depth|inlineStyleRanges|entityRanges|data|296675|SELECT+*+FROM+sys.objects
WHERE+type+=+'PK'+
AND++object_id+=+OBJECT_ID+('tableName')|code-block|syntax|javascript|296676|或者这个..。|296677|SELECT+*+FROM+sys.objects
WHERE+type+=+'PK'+
AND++parent_object_id+=+OBJECT_ID+('tableName')|296678|我认为它们中的一个可能会工作，这取决于数据是如何存储的，但我恐怕无法访问SQL来实际验证这一点。|296679|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

From memory, it's either this 

<pre><code>SELECT * FROM sys.objects
WHERE type = 'PK' 
AND object_id = OBJECT_ID ('tableName')
</code></pre>

or this.. 

<pre><code>SELECT * FROM sys.objects
WHERE type = 'PK' 
AND parent_object_id = OBJECT_ID ('tableName')
</code></pre>

I think one of them should probably work depending on how the data is stored
but I am afraid I have no access to SQL to actually verify the same.

blocks|key|294908|text|SELECT+COLUMN_NAME+FROM+{DATABASENAME}.INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE+TABLE_NAME+LIKE+'{TABLENAME}'+AND+CONSTRAINT_NAME+LIKE+'PK%25'|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|294909|unstyled|294910|，其中|blockquote|294911|294912|{DATABASENAME}+=来自您的服务器的数据库|294913|{TABLENAME}+=您希望从中查看主键的表名。|294914|注意:请输入数据库名称和表名称，不要用括号括起来。|294915|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|S|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|T|8|@]|9|@]|A|$]]|$1|I|3|-4|5|E|7|U|8|@]|9|@]|A|$]]|$1|J|3|K|5|E|7|V|8|@]|9|@]|A|$]]|$1|L|3|M|5|E|7|W|8|@]|9|@]|A|$]]|$1|N|3|O|5|E|7|X|8|@]|9|@]|A|$]]|$1|P|3|-4|5|E|7|Y|8|@]|9|@]|A|$]]]|Q|$]]

<pre><code>SELECT COLUMN_NAME FROM {DATABASENAME}.INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE TABLE_NAME LIKE '{TABLENAME}' AND CONSTRAINT_NAME LIKE 'PK%'
</code></pre>

<blockquote>
 WHERE 
 {DATABASENAME} = your database from your server AND 
 {TABLENAME} = your table name from which you want to see the primary key.
 
 NOTE : enter your database name and table name without brackets.
</blockquote>

blocks|key|296689|text|select+*+
from+sysobjects+
where+xtype='pk'+and+
+++parent_obj+in+(select+id+from+sysobjects+where+name='tablename')|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|296690|这将在sql+2005中起作用。|unstyled|296691|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre><code>select * 
from sysobjects 
where xtype='pk' and 
 parent_obj in (select id from sysobjects where name='tablename')
</code></pre>

this will work in sql 2005

blocks|key|3230884|text|我将给出的代码不仅可以工作并检索键，还可以从SQL+Server中的表中检索大量数据。是在SQL+Server+2k5/2k8中测试的，不知道大约2k。享受吧！|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3230885|SELECT+DISTINCT
++++sys.tables.object_id+AS+TableId,
++++sys.columns.column_id+AS+ColumnId,
++++sys.columns.name+AS+ColumnName,
++++sys.types.name+AS+TypeName,
++++sys.columns.precision+AS+NumericPrecision,
++++sys.columns.scale+AS+NumericScale,
++++sys.columns.is_nullable+AS+IsNullable,
++++(+++SELECT+
++++++++++++COUNT(column_name)
++++++++FROM+
++++++++++++INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE+
++++++++WHERE
++++++++++++TABLE_NAME+=+sys.tables.name+AND
++++++++++++CONSTRAINT_NAME+=
++++++++++++++++(+++SELECT
++++++++++++++++++++constraint_name
++++++++++++++++++++FROM+
++++++++++++++++++++++++INFORMATION_SCHEMA.TABLE_CONSTRAINTS
++++++++++++++++++++WHERE
++++++++++++++++++++++++TABLE_NAME+=+sys.tables.name+AND++++++++++++++++++++
++++++++++++++++++++++++constraint_type+=+'PRIMARY+KEY'+AND
++++++++++++++++++++++++COLUMN_NAME+=+sys.columns.name
++++++++++++++++)
++++)+AS+IsPrimaryKey,
++++sys.columns.max_length+/+2+AS+CharMaxLength+/*BUG*/
FROM+
++++sys.columns,+sys.types,+sys.tables+
WHERE
++++sys.tables.object_id+=+sys.columns.object_id+AND
++++sys.types.system_type_id+=+sys.columns.system_type_id+AND
++++sys.types.user_type_id+=+sys.columns.user_type_id+AND
++++sys.tables.name+=+'TABLE'
ORDER+BY+
++++IsPrimaryKey|code-block|syntax|javascript|3230886|您只能使用主键部分，但我认为其他部分可能会变得很方便。致以最好的问候，大卫|3230887|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

The code I'll give you works and retrieves not only keys, but a lot of data from a table in SQL Server. Is tested in SQL Server 2k5/2k8, dunno about 2k. Enjoy!

<pre><code>SELECT DISTINCT
 sys.tables.object_id AS TableId,
 sys.columns.column_id AS ColumnId,
 sys.columns.name AS ColumnName,
 sys.types.name AS TypeName,
 sys.columns.precision AS NumericPrecision,
 sys.columns.scale AS NumericScale,
 sys.columns.is_nullable AS IsNullable,
 ( SELECT 
 COUNT(column_name)
 FROM 
 INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE 
 WHERE
 TABLE_NAME = sys.tables.name AND
 CONSTRAINT_NAME =
 ( SELECT
 constraint_name
 FROM 
 INFORMATION_SCHEMA.TABLE_CONSTRAINTS
 WHERE
 TABLE_NAME = sys.tables.name AND 
 constraint_type = 'PRIMARY KEY' AND
 COLUMN_NAME = sys.columns.name
 )
 ) AS IsPrimaryKey,
 sys.columns.max_length / 2 AS CharMaxLength /*BUG*/
FROM 
 sys.columns, sys.types, sys.tables 
WHERE
 sys.tables.object_id = sys.columns.object_id AND
 sys.types.system_type_id = sys.columns.system_type_id AND
 sys.types.user_type_id = sys.columns.user_type_id AND
 sys.tables.name = 'TABLE'
ORDER BY 
 IsPrimaryKey
</code></pre>

You can use only the primary key part, but I think that the rest might become handy.
Best regards,
David

blocks|key|3016871|text|这应该列出所有的约束，在最后你可以把你的过滤器放入|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|3016872|/*+CAST+IS+DONE+,+SO+THAT+OUTPUT+INTEXT+FILE+REMAINS+WITH+SCREEN+LIMIT*/
WITH+++ALL_KEYS_IN_TABLE+(CONSTRAINT_NAME,CONSTRAINT_TYPE,PARENT_TABLE_NAME,PARENT_COL_NAME,PARENT_COL_NAME_DATA_TYPE,REFERENCE_TABLE_NAME,REFERENCE_COL_NAME)+
AS
(
SELECT++CONSTRAINT_NAME=+CAST+(PKnUKEY.name+AS+VARCHAR(30))+,
++++++++CONSTRAINT_TYPE=CAST+(PKnUKEY.type_desc+AS+VARCHAR(30))+,
++++++++PARENT_TABLE_NAME=CAST+(PKnUTable.name+AS+VARCHAR(30))+,
++++++++PARENT_COL_NAME=CAST+(+PKnUKEYCol.name+AS+VARCHAR(30))+,
++++++++PARENT_COL_NAME_DATA_TYPE=++oParentColDtl.DATA_TYPE,++++++++
++++++++REFERENCE_TABLE_NAME=''+,
++++++++REFERENCE_COL_NAME=''+

FROM+sys.key_constraints+as+PKnUKEY
++++INNER+JOIN+sys.tables+as+PKnUTable
++++++++++++ON+PKnUTable.object_id+=+PKnUKEY.parent_object_id
++++INNER+JOIN+sys.index_columns+as+PKnUColIdx
++++++++++++ON+PKnUColIdx.object_id+=+PKnUTable.object_id
++++++++++++AND+PKnUColIdx.index_id+=+PKnUKEY.unique_index_id
++++INNER+JOIN+sys.columns+as+PKnUKEYCol
++++++++++++ON+PKnUKEYCol.object_id+=+PKnUTable.object_id
++++++++++++AND+PKnUKEYCol.column_id+=+PKnUColIdx.column_id
+++++INNER+JOIN+INFORMATION_SCHEMA.COLUMNS+oParentColDtl
++++++++++++ON+oParentColDtl.TABLE_NAME=PKnUTable.name
++++++++++++AND+oParentColDtl.COLUMN_NAME=PKnUKEYCol.name
UNION+ALL
SELECT++CONSTRAINT_NAME=+CAST+(oConstraint.name+AS+VARCHAR(30))+,
++++++++CONSTRAINT_TYPE='FK',
++++++++PARENT_TABLE_NAME=CAST+(oParent.name+AS+VARCHAR(30))+,
++++++++PARENT_COL_NAME=CAST+(+oParentCol.name+AS+VARCHAR(30))+,
++++++++PARENT_COL_NAME_DATA_TYPE=+oParentColDtl.DATA_TYPE,+++++
++++++++REFERENCE_TABLE_NAME=CAST+(+oReference.name+AS+VARCHAR(30))+,
++++++++REFERENCE_COL_NAME=CAST+(oReferenceCol.name+AS+VARCHAR(30))+
FROM+sys.foreign_key_columns+FKC
++++INNER+JOIN+sys.sysobjects+oConstraint
++++++++++++ON+FKC.constraint_object_id=oConstraint.id+
++++INNER+JOIN+sys.sysobjects+oParent
++++++++++++ON+FKC.parent_object_id=oParent.id
++++INNER+JOIN+sys.all_columns+oParentCol
++++++++++++ON+FKC.parent_object_id=oParentCol.object_id+/*+ID+of+the+object+to+which+this+column+belongs.*/
++++++++++++AND+FKC.parent_column_id=oParentCol.column_id/*+ID+of+the+column.+Is+unique+within+the+object.Column+IDs+might+not+be+sequential.*/
++++INNER+JOIN+sys.sysobjects+oReference
++++++++++++ON+FKC.referenced_object_id=oReference.id
++++INNER+JOIN+INFORMATION_SCHEMA.COLUMNS+oParentColDtl
++++++++++++ON+oParentColDtl.TABLE_NAME=oParent.name
++++++++++++AND+oParentColDtl.COLUMN_NAME=oParentCol.name
++++INNER+JOIN+sys.all_columns+oReferenceCol
++++++++++++ON+FKC.referenced_object_id=oReferenceCol.object_id+/*+ID+of+the+object+to+which+this+column+belongs.*/
++++++++++++AND+FKC.referenced_column_id=oReferenceCol.column_id/*+ID+of+the+column.+Is+unique+within+the+object.Column+IDs+might+not+be+sequential.*/

)

select+*+from+++ALL_KEYS_IN_TABLE
where+++
++++PARENT_TABLE_NAME++in+('YOUR_TABLE_NAME')+
++++or+REFERENCE_TABLE_NAME++in+('YOUR_TABLE_NAME')
ORDER+BY+PARENT_TABLE_NAME,CONSTRAINT_NAME;|code-block|syntax|javascript|3016873|如需参考，请通读http://blogs.msdn.com/b/sqltips/archive/2005/09/16/469136.aspx|3016874|entityMap|0|LINK|mutability|MUTABLE|url|http://blogs.msdn.com/b/sqltips/archive/2005/09/16/469136.aspx^0|0|P|0|0|8|1Q|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|X|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|Y|8|@]|D|@$9|Z|A|10|1|11]]|E|$]]|$1|M|3|-4|5|6|7|12|8|@]|D|@]|E|$]]]|N|$O|$5|P|Q|R|E|$S|T]]]]

This should list all the constraints and at the end you can put your filters

<pre><code>/* CAST IS DONE , SO THAT OUTPUT INTEXT FILE REMAINS WITH SCREEN LIMIT*/
WITH ALL_KEYS_IN_TABLE (CONSTRAINT_NAME,CONSTRAINT_TYPE,PARENT_TABLE_NAME,PARENT_COL_NAME,PARENT_COL_NAME_DATA_TYPE,REFERENCE_TABLE_NAME,REFERENCE_COL_NAME) 
AS
(
SELECT CONSTRAINT_NAME= CAST (PKnUKEY.name AS VARCHAR(30)) ,
 CONSTRAINT_TYPE=CAST (PKnUKEY.type_desc AS VARCHAR(30)) ,
 PARENT_TABLE_NAME=CAST (PKnUTable.name AS VARCHAR(30)) ,
 PARENT_COL_NAME=CAST ( PKnUKEYCol.name AS VARCHAR(30)) ,
 PARENT_COL_NAME_DATA_TYPE= oParentColDtl.DATA_TYPE, 
 REFERENCE_TABLE_NAME='' ,
 REFERENCE_COL_NAME='' 

FROM sys.key_constraints as PKnUKEY
 INNER JOIN sys.tables as PKnUTable
 ON PKnUTable.object_id = PKnUKEY.parent_object_id
 INNER JOIN sys.index_columns as PKnUColIdx
 ON PKnUColIdx.object_id = PKnUTable.object_id
 AND PKnUColIdx.index_id = PKnUKEY.unique_index_id
 INNER JOIN sys.columns as PKnUKEYCol
 ON PKnUKEYCol.object_id = PKnUTable.object_id
 AND PKnUKEYCol.column_id = PKnUColIdx.column_id
 INNER JOIN INFORMATION_SCHEMA.COLUMNS oParentColDtl
 ON oParentColDtl.TABLE_NAME=PKnUTable.name
 AND oParentColDtl.COLUMN_NAME=PKnUKEYCol.name
UNION ALL
SELECT CONSTRAINT_NAME= CAST (oConstraint.name AS VARCHAR(30)) ,
 CONSTRAINT_TYPE='FK',
 PARENT_TABLE_NAME=CAST (oParent.name AS VARCHAR(30)) ,
 PARENT_COL_NAME=CAST ( oParentCol.name AS VARCHAR(30)) ,
 PARENT_COL_NAME_DATA_TYPE= oParentColDtl.DATA_TYPE, 
 REFERENCE_TABLE_NAME=CAST ( oReference.name AS VARCHAR(30)) ,
 REFERENCE_COL_NAME=CAST (oReferenceCol.name AS VARCHAR(30)) 
FROM sys.foreign_key_columns FKC
 INNER JOIN sys.sysobjects oConstraint
 ON FKC.constraint_object_id=oConstraint.id 
 INNER JOIN sys.sysobjects oParent
 ON FKC.parent_object_id=oParent.id
 INNER JOIN sys.all_columns oParentCol
 ON FKC.parent_object_id=oParentCol.object_id /* ID of the object to which this column belongs.*/
 AND FKC.parent_column_id=oParentCol.column_id/* ID of the column. Is unique within the object.Column IDs might not be sequential.*/
 INNER JOIN sys.sysobjects oReference
 ON FKC.referenced_object_id=oReference.id
 INNER JOIN INFORMATION_SCHEMA.COLUMNS oParentColDtl
 ON oParentColDtl.TABLE_NAME=oParent.name
 AND oParentColDtl.COLUMN_NAME=oParentCol.name
 INNER JOIN sys.all_columns oReferenceCol
 ON FKC.referenced_object_id=oReferenceCol.object_id /* ID of the object to which this column belongs.*/
 AND FKC.referenced_column_id=oReferenceCol.column_id/* ID of the column. Is unique within the object.Column IDs might not be sequential.*/

)

select * from ALL_KEYS_IN_TABLE
where 
 PARENT_TABLE_NAME in ('YOUR_TABLE_NAME') 
 or REFERENCE_TABLE_NAME in ('YOUR_TABLE_NAME')
ORDER BY PARENT_TABLE_NAME,CONSTRAINT_NAME;
</code></pre>

For reference please read thru - <a href="http://blogs.msdn.com/b/sqltips/archive/2005/09/16/469136.aspx" rel="nofollow">http://blogs.msdn.com/b/sqltips/archive/2005/09/16/469136.aspx</a>

blocks|key|294921|text|请记住，如果您想要获得准确的主字段，则需要将TABLE_NAME和TABLE_SCHEMA放入条件中。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|294922|这个解决方案应该是可行的：|294923|select+COLUMN_NAME+from+information_schema.KEY_COLUMN_USAGE+
where+CONSTRAINT_NAME='PRIMARY'+AND+TABLE_NAME='TABLENAME'+
AND+TABLE_SCHEMA='DATABASENAME'|code-block|syntax|javascript|294924|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Keep in mind that if you want to get exact primary field you need to put TABLE_NAME and TABLE_SCHEMA into the condition.

this solution should work:

<pre><code>select COLUMN_NAME from information_schema.KEY_COLUMN_USAGE 
where CONSTRAINT_NAME='PRIMARY' AND TABLE_NAME='TABLENAME' 
AND TABLE_SCHEMA='DATABASENAME'
</code></pre>

blocks|key|291738|text|它也是(Transact-SQL)+...根据BOL的说法。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|291739|--+exec+sp_serveroption+'SERVER+NAME',+'data+access',+'true'+--execute+once++

EXEC+sp_primarykeys+@table_server+=+N'server_name',+
++@table_name+=+N'table_name',
++@table_catalog+=+N'db_name',+
++@table_schema+=+N'schema_name';+--frequently+'dbo'|code-block|syntax|javascript|291740|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

It is also (Transact-SQL) ... according to BOL. 

<pre><code>-- exec sp_serveroption 'SERVER NAME', 'data access', 'true' --execute once 

EXEC sp_primarykeys @table_server = N'server_name', 
 @table_name = N'table_name',
 @table_catalog = N'db_name', 
 @table_schema = N'schema_name'; --frequently 'dbo'
</code></pre>

I want to get a particular table's primary key using SQL query for SQL Server database.

In MySQL I am using following query to get table primary key:

<pre><code>SHOW KEYS FROM tablename WHERE Key_name = 'PRIMARY'
</code></pre>

What is equivalent of above query for SQL Server ?.

If There is a query that will work for both MySQL and SQL Server then It will be an ideal case.

SQL Server: Get table primary key using sql query

SQL Server

数据库

服务器

MySQL

我想使用SQL Server数据库的SQL query来获取特定表的主键。在MySQL中，我使用以下查询来获取表主键：SHOW KEYS FROM tablename WHERE Key_name = 'PRIMARY'对于SQL Server，上述查询的等价物是什么？如果有一个查询同时适用于MySQL和SQL Server，那么这将是一个理想的情况。

问SQL Server:使用sql查询获取表主键
EN

回答 10

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SQL Server:使用sql查询获取表主键EN

回答 10

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SQL Server:使用sql查询获取表主键
EN