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
What are subquery and its properties?
What are views in ms sql server?
Explain active/passive and active/active cluster configurations?
How do we know if any query is retrieving a large amount of data or very little data?
What will be query used to get the list of triggers in a database?
Tell me what is log shipping?
What is ssl in sql server?
Why the trigger fires multiple times in single login?
Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?
What is the difference between web edition and business edition?
Explain comment on transactions?
Can you please explain the difference between function and stored procedure?
What are statistics?
Which is the main third-party tool used in sql server?
what are the types of indexes? : Sql server database administration