Interested to Buy Any Domain ? << Click Here >> for more details...
Can I remove the default constraint columns in SQL SERVER?
- 5 Answers
- 15451 Views
- Value Labs, I also Faced
- E-Mail Answers
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
After removing a table from database, what other related objects have to be dropped explicitly?
How do I edit a procedure in sql server?
How to change a login name in ms sql server?
What is scheduled job and how to create it?
Why would you call update statistics?
What is table-valued sub query?
Is a primary key unique?
What are null values in ms sql server?
How can you insert null values in a column while inserting the data?
What is master database? : SQL Server Architecture
how would you improve etl (extract, transform, load) throughput?
What is global temp table?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
Define master database?
How many servers can we create in a single subscription?
