Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What are subquery and its properties?

1099


What are views in ms sql server?

1118


Explain active/passive and active/active cluster configurations?

1109


How do we know if any query is retrieving a large amount of data or very little data?

1033


What will be query used to get the list of triggers in a database?

1053


Tell me what is log shipping?

1032


What is ssl in sql server?

1132


Why the trigger fires multiple times in single login?

1280


Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?

125


What is the difference between web edition and business edition?

113


Explain comment on transactions?

1041


Can you please explain the difference between function and stored procedure?

1047


What are statistics?

1050


Which is the main third-party tool used in sql server?

992


what are the types of indexes? : Sql server database administration

1178