Forum Discussion

pmscorca's avatar
pmscorca
Icon for Post Prodigy rankPost Prodigy
2 years ago
Solved

Creating a primary key for a warehouse table

Hi, I've tried to create a primary key for a warehouse table, using this documented sintax, respect two columns: ALTER TABLE PrimaryKeyTable ADD CONSTRAINT PK_PrimaryKeyTable PRIMARY KEY NONCLUSTE...
data warehouse
warehouse
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi pmscorca ,

    I got a confirmation from internal team that for time being, you can ignore the red unline under ENFORCED keyword. You will be able to execute the query without any issue.

    Coming to your second question, at present we don't have any icon notation for primary keys.

    However, your suggestion is definitely valuable! We use customer feedback like yours to prioritize future features. The more users who request the ability to customize backgrounds, the higher it moves on our list.

     

    Appreciate if you could share the feedback on our Microsoft Fabric Ideas. Which would be open for the user community to upvote & comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.

     

    I hope this information helps. If you have any further queries please do let us know.

    Thanks

     

pmscorca's avatar
pmscorca
Icon for Post Prodigy rankPost Prodigy
2 years ago

Hi, I can see the created primary key using SQL Server Management Studio, a client tool that doesn't represent an integrated experience.

Moreover, when I open the Visual Query Builder I can see the created primary key yet.

In the Data warehouse explorer the primary keys aren't visible; this explorer represents an immediate experience that shows the data types and not the primary keys.