---
title: "Sql Alias"  
description: "Sql Alias"  
author: "Manish Kumar"  
published: 2017-12-18  
updated: 2020-09-20  
canonical: https://www.mindstick.com/interview/23337/sql-alias  
category: "database"  
tags: ["database", "sql server"]  
reading_time: 1 minute  

---

# Sql Alias

Sql Alias are use to rename a table or a column name temporarily by giving another name.

It mekes table or column name more readable.

An alias only exists for the duration of the query.

##### syntax for Alias Column

```
SELECT column_name AS alias_name
FROM table_name;
```

##### Synatax for Alias Table

```
SELECT column_name(s)
FROM table_name AS alias_name;
```

## Answers

### Answer by Manish Kumar

Sql Alias are use to rename a table or a column name temporarily by giving another name.

It mekes table or column name more readable.

An alias only exists for the duration of the query.

##### syntax for Alias Column

```
SELECT column_name AS alias_name
FROM table_name;
```

##### Synatax for Alias Table

```
SELECT column_name(s)
FROM table_name AS alias_name;
```


---

Original Source: https://www.mindstick.com/interview/23337/sql-alias

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.