Wei Shi wrote:
> Hi, does anyone know how to get the schema information
> of a table. More specifically, I would like to know
>
> 1. which field(s) are primary keys?
> 2. the data type of each field of a table?
> 3. If a field is a foreign key, what field/table it
> is referring to.
Use the information schema views.