Table Transact-SQL Enhancements
The document is archived and information here might be outdated

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 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.
Show:
© 2016 Microsoft