... or you could simply use the built-in functionality in SSMS. Highlight the table name, and hit ALT+F1. It will give you all kinds of useful table metadata, including:

- Column data types and lengths

- Identity field, seed, increment if present

- Filegroup

- Index names

- Foreign Keys from this table

- Foreign Keys to this table