NULL / NOT NULL - Whether the column can accept null values.ĬLUSTERED | NONCLUSTERED - The type of index is created for a PRIMARY KEY or UNIQUE constraint. NOT FOR REPLICATION - Do not enforce constraints for the replication agent (IDENTITY, FOREIGN KEY and CHECK constraints.)ĬONSTRAINT - Define a PRIMARY KEY, NOT NULL, UNIQUE, FOREIGN KEY, or CHECK constraint. ONLINE - Make underlying tables and associated indexes are available during the index operation. IDENTITY - An identity column, one per table: tinyint, smallint, int, bigint, decimal(p,0), or numeric(p,0) TEXTIMAGE_ON - Specifies an alternate storage filegroup for columns of type: text, ntext, image, xml, varchar(max), nvarchar(max), varbinary(max), and CLR user-defined type.ĬONTENT - Allow multiple top-level elements in each instance of the xml data type.ĭOCUMENT - Allow only one top-level element in each instance of the xml data type.ĭEFAULT - A value provided for the column when nothing is explicitly supplied during an insert. The name 'timestamp' is used if no name is specified for a timestamp data type column. ALTER TABLE table ALTER COLUMN column xml_schema_collection ) ]ĪLL - All constraints or triggers in the table are enabled or disabled.Ĭolumn - A maximum of 128 characters.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |