Can I remove the default constraint columns in SQL SERVER?
- 5 Answers
- 13879 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
Explain indexes disadvantages?
What is the Main Difference between ACCESS and SQL SERVER?
What is attribute relationships, why we need it? : sql server analysis services, ssas
What are transactions in sql?
What is inline table-value user-defined function?
What is the purpose of floor function?
What are the steps you should follow to start sql server in single-user mode?
How to delete an existing row with delete statements in ms sql server?
what is a correlated sub-query? : Sql server database administration
How to list all triggers in the database with sys.triggers in ms sql server?
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
What are the elements of dbms?
When to use null data driven subscription?
How do I port a number to sql server?
How do I find query history in sql server?
