>I have a Create table statement which creates a table of about 200 fields. I keep getting a syntax error and I'm guessing it is because the line is so long. How do I use create table when I have a long list of fields?
Use the ALTER TABLE command for each field that you can't fit into the original CREATE TABLE statement...For example:
CREATE TABLE test (name C(40), address C(40))
*** Table has two fields/columns
ALTER TABLE test ADD phone C(14)
*** Table now has three fields/columns
Unfortunately, you need a separate alter table command for each additional field.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05