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

How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?

1151

---

What is the server name in sql server?

1066

---

Can you get second highest salary from the table?

1009

---

What objects does the fn_my_permissions function reports on? : sql server security

1084

---

Explain what is row_number function?

1081

---

Explain about SQL server 2005?

1026

---

What is mean by candidate key?

1061

---

Explain what is lock escalation and what is its purpose?

981

---

Where is my database stored on the hard disk in ms sql server?

1110

---

How to delete multiple rows with one delete statement in ms sql server?

1074

---

What is a fan-out query in SQL Azure?

123

---

How would you choose between a clustered and a non-clustered index?

1019

---

What is normalization process?

1236

---

How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

1071

---

List out a number of the wants to setup a SQL Server failover cluster?

1122

---