On Friday 06 February 2004 15:00, Franco Bruno Borghesi wrote: > > Does anyone know if the ansi sql standard defines any way to do this? > I've seen the DESCRIBE TABLE/INDEX/... or SHOW TABLE/INDEX/... commands > in other databases, but I don't really know if they are extensions or > not.
There's the new information schema, which displays standard info in 7.4 - support elsewhere is variable I believe. -- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend