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 is the difference between stored procedure and user defined functions?

1175


List out the difference between union and union all in sql server?

970


What happens if null values are involved in boolean operations?

969


Distinguish between nested subquery and correlated subquery?

1021


What is Lock table in SQL?

1446


What are the disadvantages of indexes?

1070


Explain how to maintain a fill factor in existing indexes?

979


Explain the concept of view and Types of views in SQL server?

971


Tell me what are the advantages of using stored procedures?

993


Define indexes?

1028


Some queries related to SQL

963


What is dml command?

938


How to get a list of columns in a view using "sys.columns" in ms sql server?

975


your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration

962


What is the difference between TRUNCATE and DROP?

1108