- Jun 6, 2020
- 11,517
- 4,383
Hello and a warm welcome to all of You.
I looked throught the internet and the forum but I did not find a clear and working solution for an easy (?) question.
I knew something about the sql PRAGMA Function but it does not deliver an information about the the columns type unique.
On some pages I read the information to use the PRAGMA index Function but what is if the respected column has no index? Or is an index auto genereated if a column is declared as unique?
My question: "What is to do to retrive the information from the Schema wether a columns type is unique or not". A small snipped of a B4A code solution would be welcome.
Thank you in advance and stay well
Guenter
I looked throught the internet and the forum but I did not find a clear and working solution for an easy (?) question.
I knew something about the sql PRAGMA Function but it does not deliver an information about the the columns type unique.
On some pages I read the information to use the PRAGMA index Function but what is if the respected column has no index? Or is an index auto genereated if a column is declared as unique?
My question: "What is to do to retrive the information from the Schema wether a columns type is unique or not". A small snipped of a B4A code solution would be welcome.
Thank you in advance and stay well
Guenter
برای دیدن لینک ها باید ثبت نام کنید