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
What is pessimistic concurrency?
What happens if you insert a duplicate key for the primary key column in ms sql server?
What are pages and extents? : SQL Server Architecture
Which language is supported by sql server?
If you want to send some data from access database to sql server database. What are different component of ssis will you use?
What are different types of raid configurations? : SQL Server Architecture
Difference between group by clause and having clause in SQL?
How to execute a sql statement using odbc_exec()?
What is the maximum number of instances in 32 bit and 64 bit sql server 2012?
How do I create a partition table in sql server?
Explain about local stored procedure?
Write the queries for commands like Create Table, Delete table, Drop Table etc.
What is named calculation? : sql server analysis services, ssas
What is difference between joins and subqueries?
What are the two modes of authentication in sql server?