Hello Bill, select COLUMN_NAME, DATA_TYPE from information_schema.columns where TABLE_NAME = "YourTable"
There are lots of other useful field too. Should work like any other table queried via ODBC. Regards, Warren Vick Europa Technologies Ltd. http://www.europa-tech.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bill Thoen Sent: Sunday, January 13, 2002 3:52 PM To: MapInfo-L Subject: MI-L SQL Server table schema accessed from MapBasic? Does anyone here know how to access field names and types from tables via an ODBC connection to databases in SQL Server? -- - Bill Thoen ------------------------------------------------------------ GISnet, 1401 Walnut St., Suite C, Boulder, CO 80302 tel: 303-786-9961, fax: 303-443-4856 mailto:[EMAIL PROTECTED], http://www.gisnet.com ------------------------------------------------------------ _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body. _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
