Sams Teach Yourself SQL in 24 Hours, Second Edition

Q&A

Q1:	How can a view contain data but take no storage space?
A1:	A view does not contain data. A view is a virtual table or a stored query. The only space required for a view is for the actual view creation statement, called the view definition.
Q2:	What happens to the view if a table from which a view was created is dropped?
A2:	The view is invalid because the underlying data for the view no longer exists.
Q3:	What are limits on naming the synonym when creating synonyms?
A3:	This is implementation-specific. However, the naming convention for synonyms in most major implementations follows the same rules that apply to the tables and other objects in the database.