Hi raylop1,
You can use sp_help [TableName] to get the Detailed Structure of any table in your Database. For example: for your PRODUCT table you can use:
sp_help [PRODUCT]
This will return the Detailed Structure of [PRODUCT] Table.
Please let us know if this was helpful.