Answers for "drop column sql with constraints"

drop columnsql

ALTER TABLE table_name
DROP COLUMN column_name

Posted by: Guest on December-23-2020

drop table with constraints

1. 'First Drop contrstraints like this'
ALTER TABLE table_name
DROP CONSTRAINT constraint_name;
2. 'Then drop table'
DROP TABLE table_name;

Posted by: Guest on February-19-2021

How to drop columns with constraint from a table in sql script

alter table tableName drop constraint [ConstraintName]
go
alter table tableName drop column columnName

Posted by: Guest on January-05-2021

Code answers related to "drop column sql with constraints"