Answer Posted / yashwanth

constraints are the rules enforced on data columns on a
table
use:constraints are used to limit the type of data that
can go in to a table

there are some constraints
a primarykey constraint
a unquekey constraint
a foreinkey constraint
a check constraint
a not null constraint
a default constraint

Can you roll back the ddl statement in a trigger?

1021

---

If no size is defined while creating the database, what size will the database have?

1036

---

What are the difference between data mart and data warehouse? : sql server analysis services, ssas

1012

---

Why are views required in the sql server or in any other database?

1004

---

what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

1114

---

How to use go command in "sqlcmd"?

1268

---

What are the extra roles available in msdb? : sql server security

1183

---

How do I find the size of a sql server database?

983

---

What are the functions in sql server?

994

---

What is Cross Join and in which scenario do we use Cross Join?

1061

---

How to add code to the existing article (using improve article)?

1167

---

What is the full form of dql?

1028

---

How to see the event list of an existing trigger using sys.trigger_events?

1137

---

what is normalization? Explain different levels of normalization? : Sql server database administration

1414

---

What is the fillfactor concept in indexes?

1037

---