Solved

delete a column from table

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

column1
table1
0
Comment
Question by:rgb192
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 23

Expert Comment

by:Rajkumar Gs
ID: 34953760
ALTER TABLE table1column1
DROP COLUMN ColumnName
0
 
LVL 23

Expert Comment

by:Rajkumar Gs
ID: 34953761
Oops!
ALTER TABLE table1
DROP COLUMN ColumnName

Open in new window

0
 
LVL 23

Accepted Solution

by:
Rajkumar Gs earned 125 total points
ID: 34953768
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
ID: 34954256
thanks
0

Featured Post

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…

729 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