Chat now with support
Chat with Support

LiteSpeed for SQL Server 8.9.5 - User Guide

About Backing Up/Restoring with LiteSpeed LiteSpeed User Interface Configure LiteSpeed for First Use Cloud Back Up Databases Automate Maintenance Tasks Restore Databases Restore Objects View Activity and History Use Command-Line Interface Use Extended Stored Procedures Troubleshoot LiteSpeed Review Additional Resources

Log Reader - Supported DDL/DML

DDL Commands

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

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating