Subject | Find Primary Key for a table |
---|---|
Author | Steve Harp |
Post date | 2006-02-06T01:40:40Z |
Hi All,
Is there a query I can execute against the system tables that will
give me the fields contained in the primary key for a table?
select the_fields
from rdb$whatever
where the_table = 'my_table_name'
Thanks,
Steve
Is there a query I can execute against the system tables that will
give me the fields contained in the primary key for a table?
select the_fields
from rdb$whatever
where the_table = 'my_table_name'
Thanks,
Steve