Can I remove the default constraint columns in SQL SERVER?
Answer Posted / 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 |
Post New Answer View All Answers
How to create a new schema in a database?
Explain the steps to create and execute a user-defined function in the sql server?
How to scale out a federation by Sql statement?
Explain what is lock escalation and what is its purpose?
What is difference between inner join and join?
What security features are available for stored procedure?
Do you know how to make remote connection in database?
Explain transaction server auto commit?
Can You Use A Stored Procedure To Provide Data To An Ssrs Report?
What is difference between primary key and foreign key?
Do you know clustered and non-clustered index?
What are the steps you must follow to hide sql server instances?
How do clustered indexes store data?
Explain differences between web edition and business edition?
What is the difference between a stored procedure and a user defined function?