Can I remove the default constraint columns in SQL SERVER?
- 5 Answers
- 13877 Views
- Value Labs, I also Faced
- E-Mail Answers
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
Write a SQL query in order to merge two different columns into single column?
What is field with example?
Define a cross join?
Explain something about security and SQL Azure?
Explain what is lock escalation and what is its purpose?
Does partitioning help performance?
Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security
Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?
What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?
What is normalization of database? What are its benefits?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
How to delete database objects with "drop" statements in ms sql server?
How do you send email on SQL Server?
what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration
Do you know what are different types of replication in sql server?
