Table Transact-SQL Enhancements

Tables are database objects, organized in row-and-column format, that contain all the data in a database. Enhancements have been made to the following table-related DDL statements.

Enhanced DDL Statements

Enhanced statements	Description
CREATE TABLE	Allows for the following: Creating persisted computed columns. Using SET NULL and SET DEFAULT with ON UPDATE and ON DELETE clauses. Specifying max for storing large amounts of varchar, nvarchar, and varbinary data. Creating xml columns, with option to type the column to an XML schema.
ALTER TABLE	Allows for the following: Creating persisted computed columns. Using SET NULL and SET DEFAULT with ON UPDATE and ON DELETE clauses. Specifying max for storing large amounts of varchar, nvarchar, and varbinary data. Creating xml columns, with option to type the column to an XML schema.

See Also

Reference

Data Definition Language (DDL) Statements (Transact-SQL)

Other Resources

What's New and Enhanced in Transact-SQL (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance