LiteSpeed for SQL Server 8.9.7

DDL is an abbreviation of Data Definition Language. It is used to create and modify the structure of database objects in the database. Review the following for information about supported DDL objects and known limitations.

Object	Is a DDL statement containing this object reconstructed?
Table	Yes Note: May be reconstructed incorrectly when using with the following options: ALL_SPARSE_COLUMNS SPARSE COMPRESS ON partition-scheme SET (ALTER TABLE)
Index	Yes (except for SPATIAL INDEX WITH DATA_COMPRESSION = { NONE \| ROW \| PAGE })
Check constraint	Yes
Primary key	Yes
Foreign key	Yes
Unique constraint	Yes
Default constraint	Yes
Trigger	Yes
View	Yes
Default	Yes
Data Type	Yes
User-defined data type	Yes
User-defined function	Yes
User-defined procedure	Yes
Rule	Yes
Statistics	Yes
DDL trigger	Yes
XML index	Yes
Filegroup	Yes
Auditing object	Yes, except for the following: DATABASE AUDIT SPECIFICATION SERVER AUDIT SERVER AUDIT SPECIFICATION
Type	Yes (except for user-defined table type and CLR type in SQL Server 2008)
CLR type	Yes (SQL Server 2005)
In-memory tables	Yes (SQL Server 2008/2012/2014)
Clustered ColumnStore index	Yes (SQL Server 2008/2012/2014)
FileTable tables	Yes (SQL Server 2008/2012/2014)

DML Commands

DML is an abbreviation of Data Manipulation Language. It is used to insert , update , and delete data in the database. Review the following for information about supported DML objects and known limitations.

Command	Is reconstructed?
INSERT	Yes, except when used with the following options: OPTIONS ( … ) Table variable FILESTREAM Note: When using with the following options, each statement is reconstructed as several statements: VALUES (…, …), (…, …),(…, …) INSERT and WHERE, OUTPUT DELETE and WHERE, OUTPUT UPDATE and WHERE, OUTPUT
UPDATE	Yes, except when used with the FILESTREAM option. Note: The statement with the MERGE option is reconstructed as two separate statements (UPDATE and INSERT).
DELETE	Yes

Command

Is reconstructed?

INSERT

Yes, except when used with the following options:

OPTIONS ( … )
Table variable
FILESTREAM

Note: When using with the following options, each statement is reconstructed as several statements:

VALUES (…, …), (…, …),(…, …)
INSERT and WHERE, OUTPUT
DELETE and WHERE, OUTPUT
UPDATE and WHERE, OUTPUT

UPDATE

Yes, except when used with the FILESTREAM option.

Note: The statement with the MERGE option is reconstructed as two separate statements (UPDATE and INSERT).

DELETE

Yes

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

LiteSpeed for SQL Server 8.9.7 - User Guide

Log Reader - Supported DDL/DML

DDL Commands

DML Commands