---
title: "sp_dropalias (Transact-SQL) | Microsoft Docs"
ms.custom: ""
ms.date: "09/18/2015"
ms.prod: "sql-non-specified"
ms.reviewer: ""
ms.suite: ""
ms.technology: 
  - "database-engine"
ms.tgt_pltfrm: ""
ms.topic: "language-reference"
dev_langs: 
  - "TSQL"
ms.assetid: 46615017-c4f2-4586-91d9-4d66b5311ae9
caps.latest.revision: 34
author: "BYHAM"
ms.author: "rickbyh"
manager: "jhubbard"
---
# sp_dropalias (Transact-SQL)
[!INCLUDE[tsql-appliesto-ss2012-xxxx-xxxx-xxx_md](../../includes/tsql-appliesto-ss2012-xxxx-xxxx-xxx-md.md)]

  **sp_dropalias** was removed for [!INCLUDE[ssSQL11](../../includes/sssql11-md.md)]. For syntax, see [sp_dropalias (Transact-SQL)](https://msdn.microsoft.com/library/ms177513\(v=sql.105\).aspx) in earlier documentation.  
  
## Syntax  
  
```  
See previous version.  
```  
  
## Remarks