Can I remove the default constraint columns in SQL SERVER?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / pooja khanna
As i understand this question is not about removing the
constraint in a column. It is about removing the columns
containing default constraint.
If it is about removing the default constraint then given
answer no. 1 is absolutely correct.It's quite a bit similar.
However, if you want to remove column containing default
constraint,first you need to drop the default constraint
then you can remove the column/'s :-
First remove the constraint :
eg :- as answer 1.
step 1:- alter table <table-name> drop constraint
<constraint-name>
step 2: alter table <table-name>
drop column <column-name>
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / krishnakumar
table create time must constraint name is important..create
time not use constraint name don't delete don't delete
constraint column
alter table table_name drop constraint <constraint name>
table create time use this query
create table delete_table(emp_id int constraint del_pk
primary key,age int)
constraint name delere query
.............................
alter table delete_table drop constraint del_pk
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / suraj
-- CONSTRAINTS are used to limit the type of data that
can go in to a table.
-- You can have multiple CONSTRAINTS in any one column
of a table.
-- You don't have to drop CONSTRAINTS in order to be
able to drop the table.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
What are different types of statement?
What are the diifferences between the ms sql server vs mysql?
What are different type of Collation Sensitivity?
Write the queries for commands like Create Table, Delete table, Drop Table etc.
0 Answers HPCL, Hughes Systique Corporation,
What are wait types?
What is sqlcmd?
What is change tracking in sql server?
How to rename an existing column with sql server management studio?
what r steps to we need to fallow b4 kill the process?
How will you monitor replication latency in transactional replication? : sql server replication
What is sql view?
What are the types of model in sql server and explain