Transact SQL Command Syntax Reference - Professional SQL Server 2005 Reporting Services - page 629

CREATE VIEW
Creates a new view:
CREATE VIEW view_name
AS
...Select Statement
CREATE SCHEMA
Creates a new schema in SQL Server 2005 with the option of specifying a non-dbo owner with the
AUTHORIZATION clause.
CREATE SCHEMA schema_name AUTHORIZATION user_name
CREATE PARTITION FUNCTION
Creates a partition function in SQL Server 2005 to use in physically partitioning tables and indexes.
CREATE PARTITION FUNCTION partition_function_name ( input_parameter_type )
AS RANGE LEFT --or RIGHT
FOR VALUES (value1, value2, value3, ...n)
CREATE PARTITION SCHEME
This creates a partition scheme in SQL Server 2005 to use in physically partitioning tables and indexes.
CREATE PARTITION SCHEME partition_scheme_name
AS PARTITION partition_function_name
TO (filegroup1, filefroup2, filefroup3, ...n)
Script Comment Conventions
In-line comment:
SELECT ProductID, Name AS ProductName -- Comment text
Single-line comment:
/* Comment text */
-- Comment text
Comment block:
/***************************************************
spProductUpdateByCategory
Created by Paul Turley, 5-21-06
[e-mail]
Updates product price info for a category
Revisions:
5-22-06 - Fixed bug that formatted C:
drive if wrong type was passed in.
****************************************************/