Try sp_columns() Nick -----Original Message----- From: Mak Wing Lok [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 1:46 AM To: CF-Talk Subject: OT: SQL Syntax - table structure hi, this might sound stupid but i have forgotten the command. does anyone know the command to view a table structure on a database for SQL/Sybase? ********************************************************************** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ********************************************************************** ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists