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 / 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


Please Help Members By Posting Answers For Below Questions

What happens when unicode strings concatenate with non-unicode strings?

1092


What the different types of Replication and why are they used?

1071


What is a covering index?

983


What is tabulation?

951


What are partitioned views?

994


What is sql or structured query language?

1150


What are the differences between having and where clause.

966


what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration

987


What is reference section?

1000


What are four major operators that can be used to combine conditions on a where clause?

1051


What is the difference between web edition and business edition?

111


How to retrieve error messages using mssql_get_last_message()?

1054


What is a recursive stored procedure in sql server?

1175


What is transaction server distributed transaction?

1054


What do you understand by physical_only option in dbcc checkdb?

979