You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
createtableTest (
Id uniqueidentifier not nullprimary key
)
go
createtableTestRef (
Id uniqueidentifier not nullprimary keyconstraint FK_TestRef_Test_Id references Test,
)
go
I try to display TestRef - but do not observe the FK_TestRef_Test_Id as expected:
\d TestRef
BASE TABLE "dbo.TestRef"
Name | Type | Nullable | Default
------+------------------+----------+---------
Id | uniqueidentifier | "NO" |
Indexes:
"PK__TestRef__3214EC07AEDAFDCF" PRIMARY_KEY, UNIQUE, CLUSTERED (Id)
/* Would have expected the foreign key to have been displayed here */
The text was updated successfully, but these errors were encountered:
Given example DDL:
I try to display
TestRef
- but do not observe theFK_TestRef_Test_Id
as expected:The text was updated successfully, but these errors were encountered: