Beginning T-SQL with Microsoft® SQL Server® 2005 and 2008 > VIEWS

Table of Contents

Download Safari Books Online apps: Apple iOS | Android

Entire Site

Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

This Book

Beginning T-SQL with Microsoft® SQL Server® 2005 and 2008

Search

Table of Contents

Ch. 1. Introducing T-SQL and Data Management Systems

Ch. 2. SQL Server Fundamentals

Ch. 3. SQL Server Tools

Ch. 4. Introducing the T-SQL Language

Ch. 5. Data Retrieval

Ch. 6. SQL Functions

Ch. 7. Aggregation and Grouping

Ch. 8. Multi-Table Queries

Ch. 9. Advanced Queries and Scripting

Ch. 10. Transactions

Ch. 11. Advanced Capabilities

Ch. 12. T-SQL Programming Objects

Ch. 13. Creating and Managing Database Objects

Ch. 14. Analyzing and Optimizing Query Performance

Ch. 15. T-SQL in Applications and Reporting

Appx. A. Command Syntax Reference

Appx. B. System Variables and Functions Reference

Appx. C. System Stored Procedure Reference

Appx. D. Information Schema Views Reference

CONSTRAINT_COLUMN_USAGE

CONSTRAINT_TABLE_USAGE

REFERENTIAL_CONSTRAINTS

Appx. E. FileStream Objects and Syntax

Appx. F. Answers to Exercises

D.20. VIEWS

Returns one row for views that can be accessed by the current user in the current database.

Column Name	Data Type
`TABLE_CATALOG`	`nvarchar(128)`
`TABLE_SCHEMA`	`nvarchar(128)`
`TABLE_NAME`	`nvarchar(128)`
`VIEW_DEFINITION`	`nvarchar(4000)`
`CHECK_OPTION`	`varchar(7)`
`IS_UPDATABLE`	`varchar(2)`

You are currently reading a PREVIEW of this book.

Get instant access to over
$1 million worth of books and videos.

Start a Free Trial

Download Safari Books Online apps: Apple iOS | Android

This Book

Search

Contents

Section D.20. VIEWS

D.20. VIEWS