Or maybe with "Describe Table" ? On Mon, 20 Sep 2004 10:51:30 -0700, Jasper Howard <jasper@xxxxxxxxxxxxx> wrote: > don't you get that with the DEFINE `table` query? > > -- > > -------------------------------------------------------------->> > Jasper Howard :: Database Administration > ApexEleven Web Design > 1.530.559.0107 > http://www.ApexEleven.com/ > <<-------------------------------------------------------------- > "Ross Honniball" <ross@xxxxxxxxxxxxxxxxxxx> wrote in message > news:6.0.0.22.1.20040919214339.01c3a5c8@xxxxxxxxxxxxxxxxxxxxxxx > > > > Hi all, > > > > Anyone know how to access the optional COMMENT you can add to columns > > during table creation? > > > > eg. > > > > create table x (fldx char(1) COMMENT 'some comment', fldy char (1) COMMENT > > 'another comment') > > > > I want to 'get' the COMMENT field. > > > > I know it should be in the manual, but I can't find it. > > > > Thanks ... Ross > > . > > . Ross Honniball. JCU Bookshop Cairns, Qld, Australia. > > . > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php