delete a column from table

delete a column from table

column1
table1
LVL 1
rgb192Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Rajkumar GsConnect With a Mentor Software 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
 
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
 
rgb192Author Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.