4
Hello,
I should create a new virtual table, from a view on my sql server on prem.
I've created a new view on my Sql Server, with a column that contain a GUID.
So, I start to create a new virtual table, choose a correct sql server and relative view, but when the procedure start to read the columns, appear an error that indicate "No primary key on table" and i cannot create a virtual table.
There is something particolar that I must do for create a virtual table from a SQL View?
Thanks in advance
Hello,
I've already create a virtual table on Dataverse, but based on SQL table.
With SQL Table, I found correctly a key for association for my Virtual table.
But with SQL View the procedure not found a Key to associate, and the field remain uneditable.
In my Sql View there are 5 column and 1 GUID Column.
Thanks in advance
Hi,
Creating any Virtual/Custom table requires two fields minimum
1. Unique identifier - Guid field
2. Name - Primary key
Make sure you add one column apart from PK field in SQL view
Hello,
Thanks for the reply.
I've not a problem to create a new virtual table from a SQL Table.
If I create a virtual table from a SQL Table everythings works fine.
My problem is create a virtual table from a SQL View.
When I try to create a Virtual table and select SQL view like source, the procedure not find a Primary Key even if there is a Guid for each record in the view.
Any suggestions?
Thanks
Hi,
Please refer to the following video
Create a Virtual Table for SQL with the Virtual Connector Provider - YouTube
#1
André Arnaud de Cal...
291,861
Super User 2024 Season 2
#2
Martin Dráb
230,540
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
