Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 304
  • Last Modified:

delete a column from table

delete a column from table

column1
table1
0
rgb192
Asked:
rgb192
  • 3
1 Solution
 
Rajkumar GsSoftware EngineerCommented:
ALTER TABLE table1column1
DROP COLUMN ColumnName
0
 
Rajkumar GsSoftware EngineerCommented:
Oops!
ALTER TABLE table1
DROP COLUMN ColumnName

Open in new window

0
 
Rajkumar GsSoftware EngineerCommented:
For the table name and column name that you mentioned, it would be
ALTER TABLE table1
DROP COLUMN column1

Open in new window

0
 
rgb192Author Commented:
thanks
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now