In MS SQL server, you can use sp_help command to get the information about a database object. It provides information about:
- Column data type definition.
- Primary keys.
- Index names.
- Foreign key constraints.
I mostly used it to find the foreign key constraints about a table. Here is an example.