Can I remove the default constraint columns in SQL SERVER?
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
Explain differentiate between a having clause and a where clause?
How to download microsoft sql server 2005 express edition?
What does Master database contains?
What command do we use to rename a database?
Mention the differences between having and where clause.
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
Tell me what is the significance of null value and why should we avoid permitting null values?
Can you get second highest salary from the table?
Explain Geography datatype in SQL Server
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
What is constraints and its types?
What is the purpose of sql profiler in sql server?
How to add a new dsn with the odbc driver for sql server?
how would you troubleshoot blocking? : Sql server database administration
How is a full-text index updated?