Abstract
Two types of views are available in SQL Server 2000: user-defined and information schema. Developers create user-defined views with the CREATE VIEW statement. Information schema views (which have been around since version 7) come with SQL Server 2000 and were created by members of the SQL Server development team. Both types of views are discussed in this chapter.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2001 Garth Wells
About this chapter
Cite this chapter
Wells, G. (2001). Views. In: Code Centric: T-SQL Programming with Stored Procedures and Triggers. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-1145-7_8
Download citation
DOI: https://doi.org/10.1007/978-1-4302-1145-7_8
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-893115-83-5
Online ISBN: 978-1-4302-1145-7
eBook Packages: Springer Book Archive