SQL Server: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
== Foreign keys == | |||
Unlike MySQL, SQL Server does not automatically add an index when creating a foreign key constraint. | |||
== Tips == | == Tips == | ||
The equivalent of <code>describe [table]</code> (MySQL) is <code>exec sp_help [table]</code> | The equivalent of <code>describe [table]</code> (MySQL) is <code>exec sp_help [table]</code> | ||
Latest revision as of 15:19, 9 August 2019
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]