Can I remove the default constraint columns in SQL SERVER?
Answer Posted / pooja khanna
As i understand this question is not about removing the
constraint in a column. It is about removing the columns
containing default constraint.
If it is about removing the default constraint then given
answer no. 1 is absolutely correct.It's quite a bit similar.
However, if you want to remove column containing default
constraint,first you need to drop the default constraint
then you can remove the column/'s :-
First remove the constraint :
eg :- as answer 1.
step 1:- alter table <table-name> drop constraint
<constraint-name>
step 2: alter table <table-name>
drop column <column-name>
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Describe and explain about SQL native client?
What is the purpose of the master database?
what is the difference between count(*) and count(1) ?
When would you use the stored procedures or functions?
Define clusters?
Explain different types of collation sensitivity?
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
How would you add a section to a table?
How can sql injection be stopped? : sql server security
How can you ensure that the database and sql server based application perform well?
Differentiate between a local and a global temporary table?
Explain the different types of backups available in sql server? : sql server database administration
What are the diifferences between the ms sql server vs mysql?
Explain what are page splits? : SQL Server Architecture
What is the security principal at the database level that represents your session?