<div>
Thanks for clarifying that a table can only one primary key. Also thanks for the code
</div>


Thanks for clarifying that a table can only one primary key. Also thanks for the code

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I use the following code to get the primary key for a SQL table. If the table has more than one primary key<br />
how do I get a count of the number of primary keys? Thanks<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sSQL = &quot;SELECT column_name &quot;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sSQL = sSQL &amp;&nbsp;&quot;FROM INFORMATION_SCHEMA.KEY_COL<wbr />UMN_USAGE &quot;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sSQL = sSQL &amp;&nbsp;&quot;WHERE OBJECTPROPERTY(OBJECT_ID(c<wbr />onstraint_<wbr />name), 'IsPrimaryKey') = 1&quot;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sSQL = sSQL &amp;&nbsp;&quot;AND table_name = '&quot; &amp;&nbsp;oTableName &amp;&nbsp;&quot;'&quot;<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Dim connection As New SqlConnection(Globals.This<wbr />AddIn.oRIG<wbr />HT.lblConn<wbr />ectionStri<wbr />ng.Text)<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Dim cmd As New SqlCommand(sSQL, connection)<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; connection.Open()<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Get_Primary_Key = cmd.ExecuteScalar().ToStri<wbr />ng<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; connection.Close()
</div>
</div>


Hi

I use the following code to get the primary key for a SQL table. If the table has more than one primary key
how do I get a count of the number of primary keys? Thanks

            sSQL = "SELECT column_name "
                sSQL = sSQL & "FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE "
                sSQL = sSQL & "WHERE OBJECTPROPERTY(OBJECT_ID(constraint_name), 'IsPrimaryKey') = 1"
                sSQL = sSQL & "AND table_name = '" & oTableName & "'"

                Dim connection As New SqlConnection(Globals.ThisAddIn.oRIGHT.lblConnectionString.Text)
                Dim cmd As New SqlCommand(sSQL, connection)
                connection.Open()
                Get_Primary_Key = cmd.ExecuteScalar().ToString
                connection.Close()

VB.net Get a count of the number of primary keys in a SQL table

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,