Support for primary keys and foreign keys

[pmscorca]

Hi,

I'd like to know if Fabric SQL database supports the primary keys and the foreign keys for tables.

I hope that this is possible, otherwise for which reasons.

Thanks

[Srisakthi]

Hi @pmscorca ,

It supports primary key, please do check the limitations.

https://learn.microsoft.com/en-us/fabric/database/sql/limitations

Regards,

Srisakthi

[maruthisp]

Hi pmscorca,

Please check the below Microsoft documentation link:

Table constraints

SQL analytics endpoint and Warehouse in Microsoft Fabric support these table constraints:

• PRIMARY KEY is only supported when NONCLUSTERED and NOT ENFORCED are both used.
• FOREIGN KEY is only supported when NOT ENFORCED is used.
• UNIQUE constraint is only supported when NONCLUSTERED and NOT ENFORCED are both used.
  
  https://learn.microsoft.com/en-us/fabric/data-warehouse/table-constraints
  
  

  If this reply helped solve your problem, please consider clicking "Accept as Solution" so others can benefit too. And if you found it useful, a quick "Kudos" is always appreciated, thanks! 

  Best Regards, 

  Maruthi 

  LinkedIn - http://www.linkedin.com/in/maruthi-siva-prasad/ 

  X            -  Maruthi Siva Prasad - (@MaruthiSP) / X

[pmscorca]

Hi, but I'm referring to a Fabric SQL Database and not warehouse/lakehouse.

Thanks

[idrismotiwala · Accepted solution]

Hi @pmscorca , Fabric SQL database supports primary keys/foreign keys and all other objects that you may be familiar in Azure SQL Database or SQL Server.