查找作为Firebird数据库中主键的所有列名(Find all column names that are primary keys in Firebird database)

 我需要在表中找到主键的所有列并返回其列名。 
 
 有没有办法使用Firebird .net API的Connection.GetSchema()方法实现这一目标？ 如果没有，SQL语句将如何实现这一目标？ 
 
 我不需要一个完整的代码示例，但需要一些有关如何执行此操作的指导。 
 
 在我的场景中，我有一个Firebird嵌入式数据库，我想从数据库模式生成存储的prodecures。 我需要主键列名来在表上生成触发器，该表将一些元数据插入到跟踪表中。 
 
 我使用最新版本的Firebird和最新的.net连接器（v.2.5.5） 
 
 如果您需要有关我的问题的更多信息，请评论！ 

I need to find all columns in a table that are primary keys and return their column names.
 
Is there a way I can achieve this with the Connection.GetSchema() method of the Firebird .net API? If not, how would a SQL statement look like to achieve this? 
 
I don't need a complete code example but some guidance on how to do it.
 
In my scenario I have a Firebird embedded database and I want to generate stored prodecures from the database schema. I need the primary key column names to generate triggers on a table that insert some metadata into a tracking table.
 
I use the latest version of Firebird with the latest .net connector (v.2.5.5)
 
If you need more information about my problem please comment!

原文：https://stackoverflow.com/questions/36617891