SQL Server

Foreign keys

Unlike MySQL, SQL Server does not automatically add an index when creating a foreign key constraint.

Tips

The equivalent of describe [table] (MySQL) is exec sp_help [table]