# SQL Server 2018 deprecated features list
SQL Server 2018 deprecated features list

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)   |