Can I remove the default constraint columns in SQL SERVER?
Answer Posted / vikas
Default is constraint and to drop any constraint in sql server
syntax is same
Alter Table TableName Drop Constraint ConstraintName
visit :
http://www.tutorialsqlserver.com/Create/Default-Value-in-Sql-Server.htm
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between stored procedure and user defined functions?
List out the difference between union and union all in sql server?
What happens if null values are involved in boolean operations?
Distinguish between nested subquery and correlated subquery?
What is Lock table in SQL?
What are the disadvantages of indexes?
Explain how to maintain a fill factor in existing indexes?
Explain the concept of view and Types of views in SQL server?
Tell me what are the advantages of using stored procedures?
Define indexes?
Some queries related to SQL
What is dml command?
How to get a list of columns in a view using "sys.columns" in ms sql server?
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
What is the difference between TRUNCATE and DROP?