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