SQL Server: Difference between revisions
Jump to navigation
Jump to search
Created blank page |
No edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
== Foreign keys == | |||
Unlike MySQL, SQL Server does not automatically add an index when creating a foreign key constraint. | |||
== Tips == | |||
The equivalent of <code>describe [table]</code> (MySQL) is <code>exec sp_help [table]</code> | |||
Latest revision as of 14: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]