Aliasing Tables

• erics44

  SSCertifiable

  Points: 6311

  More actions

  June 13, 2016 at 3:47 am

  #314489

  Hi

  Is there a way of aliasing tables at database level?

  so every time you need the table you can just use the alias rather than the table name?

  for example I have a table called Apples, I alias it somewhere as App and then from then on I can reference it as App.

  so

  Select * from App

  Thanks in advance

• gfoxxy93

  Right there with Babe

  Points: 776

  More actions

  June 13, 2016 at 4:07 am

  #1884585

  You could create a view?

  https://msdn.microsoft.com/en-GB/library/ms187956.aspx

• DouglasH

  SSCommitted

  Points: 1669

  More actions

  June 13, 2016 at 4:08 am

  #1884586

  Or a Synonym https://technet.microsoft.com/en-us/library/ms190626(v=sql.105).aspx