Recently i ported my data from PSQL to MSSQL Server.
I never worked with MSSQL database before - i’m sure it does some good work out there…
Still the same i’m SCHOCKED when i see my tables after connecting Servoy to MSSQL Server.
What the hack are all those views/system tables, other (needed?) tables doing there in my explorer!!!
A frustrating amount of about a small 300! tables is filling up stuff where i only need - say 10 tables- to work with.
Fortunaly, Servoy thought of the idea to make a structure ( a map) under the server_icon to put the views in.
Is it not possible to put all te rest off this mumbojumbo in a seperate map also?
Dear Guru’s out there:
You would really make my day if this could be represented in a neater way.
(can i not simply throw away all that dm_db_xxx, dm_exec_xxx stuff… )
selecting that option, does not work, they are not system-tables. but default views in MSSQL. (not beginning with sys_)
in the database explorer, they are nicely seperated, with the folders: tables & views.
But if you select a dataprovider for a field, in that popup there is now seperation, between tables & views (at least not in Servoy 5.2.10)
Everything is listed in one big list.
That is what Jan pointing out here…
I’m I right Jan?
In fact for changing datasource for a form i can live with it - cause we have the input filter ( however, its still not
pretty having a ton of [for sln] unmeaningfull tables there )
I’m mostly disappointed with the fact that my lower-left panel is polluted with these tables, so again:
Like the “VIEWS” are nicely separated by Servoy, why not the “dm_db_xxx” etc… stuff?
