Table/Field Documentation

[RSfromCO]

I have a client that is thinking of moving their MS-Access databases into SQL Server. They have spent a lot of time and effort in MS-Access adding Field Description values for each field (using the Table Design View). These descriptions are important because they used rather cryptic field names.

What is the best way to provide field descriptions when you use SQL Server rather than MS-Access?

 

[JayKusch]

You would use Extended Properties.

Thanks

J. Kusch