Answer Posted / naren

sp_help tablename

another command is

select name from syscolumns where id=object_id
('table_name')

What are different types of table joins?

750

---

What is the default fill factor value?

761

---

Explain tables in SQL Azure?

114

---

Explain candidate key, alternate key, and composite key?

750

---

What are the Advantages of using CTE in sql server?

763

---

---

What are the commands used in DCL?

709

---

Explain intellisense for query editing

756

---

What is table valued function and scalar valued functions?

708

---

What does sql server mean?

693

---

what is the information that can be stored inside a bit column? : Sql server database administration

706

---

What is DCL?

762

---

List out the different types of locks available in sql server?

714

---

Explain timestamp datatype?

717

---

Explain the different index configurations a table can have?

683

---

Write a SQL command to insert and update only a particular field?

798

---