SQL Server: Difference between revisions

From Rixort Wiki
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 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]