Default is constraint and to drop any constraint in sql server syntax is

Can I remove the default constraint columns in SQL SERVER?

Question Posted / vikas

5 Answers
15076 Views
Value Labs, I also Faced
E-Mail Answers

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

Is it possible to update the views? If yes, how, if not, why?

969

How to view existing indexes on an given table using sp_help?

1054

What is database dimension? : sql server analysis services, ssas

1031

Define ACID properties in a Database?

1004

Explain aggregate functions?

1026

How to receive returning result from a query?

1034

What is the distinction amongst delete and truncate?

1000

Why should we go for stored procedures? Why not direct queries?

1026

Are resultset updatable?

895

What are a scheduled jobs?

908

Why use sub query in sql server and list out types of sub queries?

937

Define magic tables in sql server?

988

Is foreign key a primary key?

976

How can windows applications connect to sql servers via odbc?

1060

Which are the olap features?

907