This utility is useful for generating various lists and commands related to tables. The utility runs as a plain procedural program which you can run like this:

use wwdemo\tt_cust
DO tools\CRT_DBF

ShowText(_cliptext)

which generates a CREATE TABLE statement for the above table. Output can be generated for the following types:

TABLE - Create Table Command
ARRAY - Create Table using VFP's Array Syntax for large tables that exceed command lengths
INDEX - Generates INDEX tag commands for recreating indexes
BOTH - Generates table and index statements
ARRAYBOTH - Generates table and index statements using table array syntax
FIELDLIST - creates a comma delimited field list
CLASSVARS - creates a comma delimited class property list with type prefix
DOCUMENTATION - creates a line break separate list of field names and type info
HELPBUILDER - same as above but with Help Builder HTML formatting
HTMLEDITFORM - creates an HTML Form with ASP Style template fields. See GenEditRecord.prg for more details.

All output is generated to the _clipboard from which you can paste into whatever program you need to.

In case you can't remember this list there's a front end form for this tool:

To run the form:

DO FORM tools\CRT_DBF

This utility is extremely handy for use with your wwBusiness objects for the CreateTable and Reindex methods which can use the maintenance statements and apply them.