title: How to get column metadata from a table synonym
body: <p>How can I determine column metadata from a table <a href="http://msdn.microsoft.com/en-us/library/ms191230.aspx" rel="noreferrer">synonym</a> in a SQL Server 2005 database?  I have a synonym called 'ProjectSyn' for a table called 'Project', but I can find no column metadata for the synonym.</p>
  
  <p>My guess is to somewhere determine the 'base table' for the synonym, then query for column metadata for that table.  Is this a correct approach, and if not, what would be?</p>