

# SQL Server 2018 deprecated features list
<a name="chap-sql-server-aurora-mysql.deprecatedfeatures"></a>

This topic provides reference information for deprecated features from SQL Server 2018. For more information, refer to the linked topics.


| SQL Server 2018 deprecated feature | Section | 
| --- | --- | 
|  `TEXT`, `NTEXT`, and `IMAGE` data types |  [Data Types](chap-sql-server-aurora-mysql.sql.datatypes.md)  | 
|  `SET ROWCOUNT` for DML |  [Session Options](chap-sql-server-aurora-mysql.configuration.sessionoptions.md)  | 
|  `TIMESTAMP` syntax for `CREATE TABLE`  |  [Creating Tables](chap-sql-server-aurora-mysql.sql.creatingtables.md)  | 
|  `DBCC DBREINDEX`, `INDEXDEFRAG`, and `SHOWCONTIG`  |  [Maintenance Plans](chap-sql-server-aurora-mysql.management.maintenanceplans.md)  | 
| Old SQL Mail |  [Database Mail](chap-sql-server-aurora-mysql.management.databasemail.md)  | 
|  `IDENTITY` seed, increment, non primary key, and compound |  [Identity and Sequences](chap-sql-server-aurora-mysql.tsql.identitysequences.md)  | 
| Stored procedures `RETURN` values |  [Stored Procedures](chap-sql-server-aurora-mysql.tsql.storedprocedures.md)  | 
|  `GROUP BY ALL`, `Cube`, and `Compute By`  |  [GROUP BY](chap-sql-server-aurora-mysql.sql.groupby.md)  | 
| DTS |  [ETL](chap-sql-server-aurora-mysql.management.etl.md)  | 
| Old outer join syntax ` = ` and `=`  |  [Table JOIN](chap-sql-server-aurora-mysql.sql.tablejoin.md)  | 
|  `'String Alias' = Expression`  |  [Migration Quick Tips](chap-sql-server-aurora-mysql.tips.md)  | 
|  `DEFAULT` keyword for `INSERT` statements |  [Migration Quick Tips](chap-sql-server-aurora-mysql.tips.md)  | 