Interested to Buy Any Domain ? << Click Here >> for more details...
Can I remove the default constraint columns in SQL SERVER?
- 5 Answers
- 15241 Views
- Value Labs, I also Faced
- E-Mail Answers
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
Find nth lowest salary or get nth lowest salary?
what is difference between NULL and ISNULL in SQL Server 2008?
Explain the truncate command? : SQL Server Architecture
What is Sqlpaging in SqlServer 2005 ?
What is the command used to recompile the stored procedure at run time?
Why do we use non clustered index?
What is a cursor, index in sql?
Detail about the hardware which is supported by SQL server?
Give me a SQL Query to find out the second largest company?
How to delete duplicate rows from table except one?
What is difference between oltp and olap?
What are the new features in SQL Server 2005 when compared to SQL Server 2000?
What are horizontal and vertical scaling?
What are magic tables in sql server?
What is the difference between system objects and user objects?
