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 happens when unicode strings concatenate with non-unicode strings?
What the different types of Replication and why are they used?
What is a covering index?
What is tabulation?
What are partitioned views?
What is sql or structured query language?
What are the differences between having and where clause.
what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration
What is reference section?
What are four major operators that can be used to combine conditions on a where clause?
What is the difference between web edition and business edition?
How to retrieve error messages using mssql_get_last_message()?
What is a recursive stored procedure in sql server?
What is transaction server distributed transaction?
What do you understand by physical_only option in dbcc checkdb?