---
title: "What is the difference between a view and a synonym?"  
description: "What is the difference between a view and a synonym?"  
author: "Sumit Kesarwani"  
published: 2014-01-31  
updated: 2020-09-19  
canonical: https://www.mindstick.com/interview/1906/what-is-the-difference-between-a-view-and-a-synonym  
category: "mysql"  
tags: ["mysql"]  
reading_time: 1 minute  

---

# What is the difference between a view and a synonym?

Synonym is just a second name of table used for multiple link of database.View can be created with many tables, and with virtual columns and with conditions.But synonym can be on view.

## Answers

### Answer by Sumit Kesarwani

Synonym is just a second name of table used for multiple link of database.View can be created with many tables, and with virtual columns and with conditions.But synonym can be on view.


---

Original Source: https://www.mindstick.com/interview/1906/what-is-the-difference-between-a-view-and-a-synonym

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