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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

editing columns?

Status
Not open for further replies.
fowlerlfc

fowlerlfc

MIS
Mar 20, 2002
136
US
I have a table that has an unneeded column in it. How would I remove it?

I also have a field that is set at 7 characters long, but I need to change it to 8 characters long.

Any help would be greatly appreciated!

 
Sort by date Sort by votes
Answered my first question:

alter table tablename drop column columnname;
 
Upvote 0 Downvote
for you second question:

ALTER TABLE tableName
MODIFY fieldName NewDataTypeOrConstraint;
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

AbidingDude
  • Locked
  • Question
One Constraint for Multiple Columns 1
Replies
2
Views
299
AbidingDude
AbidingDude
DBrewsky
  • Locked
  • Question
Query with Multiple Columns based upon same data 1
Replies
3
Views
71
DBrewsky
DBrewsky
Auguy
  • Locked
  • Question
Trim Varchar Columns Trailing Spaces
Replies
3
Views
80
ChrisHirst
ChrisHirst
dkemas
  • Locked
  • Question
return all columns on one distinct column
Replies
2
Views
90
dkemas
dkemas
PCHomepage
  • Locked
  • Question
Join Query to Single Set of Columns 1
Replies
5
Views
114
PCHomepage
PCHomepage

Part and Inventory Search

Sponsor

Back
Top