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:
|
| 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:
|
| 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 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:
Note: When using with the following options, each statement is reconstructed as several statements:
|
| 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 |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Nutzungsbedingungen Datenschutz Cookie Preference Center
