Index and view in a database.

Hi all,

Please clear that , there is a base table named A consists 10 records , then how many records in a view. And if I delete a record from table then in the view how many records will be.

Thanks!!

It depends on the definition of the view, of course.

View in a relational database is just a stored SQL query that is executed against the table(s) whenever the view is used.

Index is yet another thing. Generally, indexes should not affect results of SQL databases; they are there to speed up some SQL queries or to enforce database constraints.

OK
one more question is that if I drop table A then index and view will be drop or not?
Thanks for your reply!

It might differ depending on the database, but generally indexes are dropped when the table is dropped. Views are usually kept in an invalid state, they are unusable until fixed.

Like Martin rightly pointed its database specific like in Oracle if you drop table view and indexes both would be dropped but in DB2 if you drop table then views on the table are marked inoperative and indexes are dropped.

Thanks all of you for a good and soon reply !

I really appreciate this Forum site.