Table Transact-SQL Enhancements

  • Article

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