I use the C# version of SharpHSQL (which is greeeeeeeeeeeeeeeeeeat by the way) but I don't think that it matters.
I create a table by executing the database.execute("CREATE TABLE...").
I get the SharpHSQL.Table back using the d.getTable("table_name", channel) command.
How can I find out which is the PRIMARY KEY column(s), the FOREIGN KEY column(s) and the UNIQUE columns?
I tried analyzing the CONSTRAINTS that I can get by using the Table.getConstraints() functions but I couldn't solve my problem.
If there is another way that I can find out about the PRIMARY KEY, FOREIGN KEY and UNIQUE constraints please tell me so!
Thanks everybody!
------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click _______________________________________________ hsqldb-developers mailing list hsqldb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
