private void CreateSPTablePrimaryKey_GetList(string storedProcedure) { var sb = new StringBuilder(); sb.AppendLine($"CREATE PROCEDURE [dbo].[{storedProcedure}]"); sb.AppendLine("AS BEGIN"); sb.AppendLine(" SET NOCOUNT ON;"); sb.AppendLine(" SELECT 1 as PrimaryKeyId, *"); sb.AppendLine(" FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS"); sb.AppendLine(" WHERE constraint_type = 'PRIMARY KEY'"); sb.AppendLine("END"); _client.ExecuteTextCommand(sb.ToString()); }