Interested to Buy Any Domain ? << Click Here >> for more details...
Can I remove the default constraint columns in SQL SERVER?
- 5 Answers
- 15272 Views
- Value Labs, I also Faced
- E-Mail Answers
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 are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
What is the server name for sql management studio?
Why truncate is ddl?
What are the differences between stored procedure and the dynamic sql?
Explain triggers?
What are key, name and value columns of an attribute? : sql server analysis services, ssas
What is tablix?
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
Why I can not enter 0.001 second in date and time literals in ms sql server?
What are the advantages of the mirroring?
how can you check the level of fragmentation on a table? : Sql server administration
How to encrypt Strored Procedure in SQL SERVER?
Explain left outer join and right outer join?
Explain few examples of stored procedure over triggers?
How to use transact-sql statements to access the database engine?
