This stored procedure will give you extensive information about the fields in a table
SP_HELP tablename