riskyricky1972
asked on
sql
Alter TABLE [table1]
Add SV int null default 1 with values,CompanyID int null default 1 with values
Alter TABLE [table2]
Add SD int null default 1 with values,CompanyID int null default 1 with values
I have above script to run and it works fine to me. But how to write script to delete the columns?
Add SV int null default 1 with values,CompanyID int null default 1 with values
Alter TABLE [table2]
Add SD int null default 1 with values,CompanyID int null default 1 with values
I have above script to run and it works fine to me. But how to write script to delete the columns?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
drop column columnname