I am a complete beginner at SQL Server. I was given a database that was in SQL Server backup file format. I figured out how to restore the databases, but now I am looking to export the tables (eventually to Stata .dta files)

I am confused how to view and extract any meta-data my SQL Server database might contain. For example, I have one column labeled `Sex` and the values are 1 and 2. However, I have no idea which number refers to male and which refers to female. How would I view the column description (if it exists) to see if there is any labeling that might be able to clarify this issue?

Edit: Quick question. If I use the Import/Export Wizard, will that automatically extract the meta-data?