Sybase Technical Library - Product Manuals Home

Return to Collection List
Enable Frames

[Search Forms] [Previous Section with Hits] [Next Section with Hits] [Clear Search] Expand Search

Table of contents for Transact-SQL User's Guide

Transact-SQL® User's Guide
About This Book
[+] Chapter 1 SQL Building Blocks
[+] Chapter 2 Queries: Selecting Data from a Table
[+] Chapter 3 Using Aggregates, Grouping, and Sorting
[+] Chapter 4 Joins: Retrieving Data from Several Tables
[+] Chapter 5 Subqueries: Using Queries Within Other Queries
[+] Chapter 6 Using and Creating Datatypes
[-] Chapter 7 Creating Databases and Tables
[+] What are databases and tables?
[+] Using and creating databases
Altering the sizes of databases
Dropping databases
[+] Creating tables
[+] Managing identity gaps in tables
[+] Defining integrity constraints for tables
[+] How to design and create a table
[+]
Creating new tables from query results: select into
[+] Altering existing tables
Dropping tables
Assigning permissions to users
[+] Getting information about databases and tables
[+] Chapter 8 Adding, Changing, and Deleting Data
[+] Chapter 9 Views: Limiting Access to Data
[+] Chapter 10 Using the Built-In Functions in Queries
[+] Chapter 11 Creating Indexes on Tables
[+] Chapter 12 Defining Defaults and Rules for Data
[+] Chapter 13 Using Batches and Control-of-Flow Language
[+] Chapter 14 Using Stored Procedures
[+] Chapter 15 Using Extended Stored Procedures
[+] Chapter 16 Triggers: Enforcing Referential Integrity
[+] Chapter 17 Cursors: Accessing Data Row by Row
[+] Chapter 18 Transactions: Maintaining Data Consistency and Recovery
[+] Chapter 19 Locking Commands and Options
[+] Appendix A The pubs2 Database
[+] Appendix B The pubs3 Database