From: Jeremy Kemper <jeremy@...>
Date: 2005-04-08T04:10:23+09:00
Subject: Re: In-depth schema details in ActiveRecord

Phrogz wrote:
> Jeremy Kemper wrote:
>>whether a column is nullable: try 'desc tablename' in your client.
> 
> Is this something that:
> a) You can discover using a SQL query?
> (I was told on on the #sql channel on IRC)

Yes; it's shorthand for "show columns from tablename"

> b) May be exposed by the engine to the MySQL adaptor?

Active Record's MySQL adapter uses this query.

jeremy