Answer Posted / shelly

Constraints are used to limit the type of data that goes
into a table.Constraints can be declared at the time of
creating a table or by altering the already created table.

1)Not Null
2)Unique
3)Primary Key
4)Check
5)References
6)Default

What is difference between temp table and cte?

965

---

What is user-defined scalar function?

920

---

what is nonclustered index

903

---

Describe triggers features and limitations?

936

---

What is the use of builtinadministrators group in sql server? : sql server security

977

---

How you can get a list of all the table constraints in a database?

918

---

Tell me what is the significance of null value and why should we avoid permitting null values?

933

---

What are the different types of indexes?

1053

---

can a table be moved to different filegroup? : Sql server administration

921

---

How to remove duplicate rows from table?

1176

---

How to see existing views in ms sql server?

997

---

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

956

---

Do you know what are the reporting services components?

931

---

What is sql server profiler trace data file?

1060

---

What are rows and columns?

961

---