Solved

delete a column from table

Posted on 2011-02-22
4
245 Views
Last Modified: 2012-05-11
delete a column from table

column1
table1
0
Comment
Question by:rgb192
  • 3
4 Comments
 
LVL 23

Expert Comment

by:Rajkumar Gs
Comment Utility
ALTER TABLE table1column1
DROP COLUMN ColumnName
0
 
LVL 23

Expert Comment

by:Rajkumar Gs
Comment Utility
Oops!
ALTER TABLE table1
DROP COLUMN ColumnName

Open in new window

0
 
LVL 23

Accepted Solution

by:
Rajkumar Gs earned 125 total points
Comment Utility
For the table name and column name that you mentioned, it would be
ALTER TABLE table1
DROP COLUMN column1

Open in new window

0
 

Author Closing Comment

by:rgb192
Comment Utility
thanks
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now