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 |
Explain about extended stored procedure?
How reterive duplicate value in SQL?
How will you add a dimension to cube? : sql server analysis services, ssas
Can we rollback records deleted by a truncate statement?
3 Answers CarrizalSoft Technologies, United Healthcare,
What is sleeping status in sql server?
What are examples of triggers?
What is the distinction amongst delete and truncate?
What part does database design plays a role in performance of an sql server-based application?
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
how do we find every fifth record in a table
What are the disadvantages of primary key and foreign key in SQL?
How to fetch records from a One to Many relationship table. eg: wanna get details of all orders for a specific customer. (do not want repeatation of master table records for child table records)