SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE Foo(ID INT PRIMARY KEY)
CREATE TABLE MyTable
(
Id int PRIMARY KEY IDENTITY(1, 1), 
FooId int NOT NULL FOREIGN KEY REFERENCES Foo(Id),
Data nvarchar(10) NOT NULL,

);
exec sp_helpIndex 'MyTable'


index_name
index_description
index_keys


PK__MyTable__3214EC0742A69968
clustered, unique, primary key located on PRIMARY
Id


DROP TABLE IF EXISTS MyTable;
CREATE TABLE MyTable
(
Id int PRIMARY KEY IDENTITY(1, 1), 
FooId int NOT NULL FOREIGN KEY REFERENCES Foo(Id),
Data nvarchar(10) NOT NULL,
INDEX FK_FooId nonclustered(FooId)
);
exec sp_helpIndex 'MyTable'


index_name
index_description
index_keys


FK_FooId
nonclustered located on PRIMARY
FooId

PK__MyTable__3214EC0779B032FB
clustered, unique, primary key located on PRIMARY
Id

index_name	index_description	index_keys
FK_FooId	nonclustered located on PRIMARY	FooId
PK__MyTable__3214EC0779B032FB	clustered, unique, primary key located on PRIMARY	Id