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. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
