Can I remove the default constraint columns in SQL SERVER?
Answer Posted / yvbchowdary
yes u can delete the default constraint. First find out the
constraint name for the default and then execute the
following quey
alter table <table-name> drop constraint <constraint-name>
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
Explain “not null constraint” in sql server?
Which is the latest version of sql server and when it is released?
How to see the event list of an existing trigger using sys.trigger_events?
What factors you will consider calculating the storage requirement for that view?
What is a group function explain with an example?
What is transaction server implicit?
How to skip remaining statements in a loop block using continue statements?
Data table as parameter in sql server?
what is spatial nonclustered index
What stored procedure would you use to view lock information?
How you provide security to cube? : sql server analysis services, ssas
How to return the top 5 rows from a select query in ms sql server?
Can two tables have the same primary key?
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
Mention the different types of replication in sql server.