SQL Querry remove

[DamanC]

Hi Guys,

 

Bit of an SQL Nub here. I want to remove an unused SQL code I added to my DB

 

The code I ran was:

 

ALTER TABLE products ADD products_cost DECIMAL( 15, 4 );

 

Is there a way to simply remove what I have added?

 

Run a code perhaps?

 

thanks

[Jan Zonjee]

I want to remove an unused SQL code I added to my DB

 

The code I ran was:

 

ALTER TABLE products ADD products_cost DECIMAL( 15, 4 );

 

Is there a way to simply remove what I have added?

ALTER TABLE products DROP COLUMN products_cost;

[DamanC]

Thankyou very much Jan :)