COPY STRUCTURE EXTENDED TO C:\TEST\FIELDS USE c:\test\fields LIST FIELDS FIELD_NAME,FIELD_TYPE, FIELD_LEN, FIELD_DEC TO FILE C:\TEST\FIELDS.TXTAnd then loaded this into a text editor!
>> >>Structure for table: C:\PHARMACY\TABLES\DRUG.DBF >>Number of data records: 191274 >>Date of last update: 11/28/06 >>Memo file block size: 64 >> Code Page: 1252 >> Field Field Name Type Width Dec Index Collate Nulls Next Step >> 1 DRUG_ID Integer 4 Asc Machine No >> 2 NDC Character 11 No >> 3 ACTIVE Logical 1 No >> 4 NAME Character 25 No >> 5 FORM Character 3 No >> 6 STRENGTH Character 8 No >> 7 SIZE Numeric 8 3 No >> 8 DEA_CLASS Character 1 No >> 9 THIRD_PARTY_.. Character 1 No >> 10 MANUFACTURER Character 30 No >> 11 SHORT_NAME Character 23 No >> 12 SHORTCUT Character 8 No >> 13 DRUG_TYPE Numeric 1 No >> 14 TOT_PKG_QTY Numeric 6 3 No >> 15 PKG_UNIT_MEA.. Character 2 No >> 16 PKG_QTY Integer 4 No >> 17 DRUG_NAME_CO.. Character 6 No >> 18 THERAPEUTIC_.. Character 10 No >>>>