Answer / anusha

No, dropping the table does not delete the corresponding table objects. Need to drop Indexes, views first before dropping the table.

eg:
drop view <database name>.<view name>
alter table <database name>.<table name> drop <index type>
drop table <database name>.<table name>

What's the purpose of Stored Procedure?

6 Answers   Wipro,

---

What is the difference between the following two sql statements select count(*) from <tablename> select count(col_name) from <tablename>

5 Answers   247Customer,

---

What is the security principal at the database level that represents your session?

0 Answers  

---

How will you collect the date from current date to last older 6 days date in sql server 2005

4 Answers  

---

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

0 Answers  

---

what is a traditional network library for sql servers? : Sql server database administration

0 Answers  

---

what is statistics

1 Answers  

---

How to retrieve error messages using odbc_errormsg()?

0 Answers  

---

What happens if null values are involved in string operations?

0 Answers  

---

How to stop a loop early with break statements in ms sql server?

0 Answers  

---

can foreign key take role of primary key?

5 Answers   CarrizalSoft Technologies, TCS, Villa Marie,

---

Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?

0 Answers  

---