Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

removing fields from a table in a program

Status
Not open for further replies.
MikeL91

MikeL91

Programmer
Feb 8, 2001
100
US
I have done this once, but lost the code, and can't seem to find the section in the book.

I want to modify a structure from my program when it runs to remove a field.


Thanks in advance,
Mike
 
Sort by date Sort by votes
Mike,
Try:
ALTER TABLE TableName1 [DROP [COLUMN] FieldName3]

Rick
 
Upvote 0 Downvote
however before executing rick's advice
ensure that data table you are modifying is in exclusive mode
[pipe]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

SitesMasstec
  • Locked
  • Solved
Copy fields from one table to another
2
Replies
26
Views
2K
SitesMasstec
SitesMasstec
Mandy_crw
  • Locked
  • Question
What is the correct or best approach in editing a table? 7
Replies
17
Views
1K
Chriss Miller
C
SitesMasstec
  • Locked
  • Question
Combobox populated with data from a table 1
Replies
8
Views
2K
igorsandler
igorsandler
Steve-vfp9user
  • Locked
  • Question
Extracting an Address from a Postcode input
Replies
11
Views
736
Steve-vfp9user
Steve-vfp9user
DDPL
  • Question
Custom class in a custom class
Replies
18
Views
742
Chriss Miller
C

Part and Inventory Search

Sponsor

Back
Top