Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Table Transact-SQL Enhancements

SQL Server 2005

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.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.