Hello everyone,
I'm currently trying to create tables through SQL but for some reason i'm getting this error:
I'm certainly doing something wrong. Hope you guys can help me.
Thanks in advance!
Best regards,
Miguel Figueiredo
Hi,
You cannot create tables through SQL in Outsystems, unless the entity is from an external database and permissions are defined they a creation of a database table is allowed.
Regards,
Daniel
Hello Daniel,
Thanks for the quick reply!
What do you recommend to practice SQL queries and creation of database tables through SQL? I started programming about two weeks ago and i've been using Service Studio, as you can see. If you could give me some tips it would be fantastic.
Hi Miguel,
I suggest if you just started with OutSystems to follow the online Guided path for Reactive Web development. It will learn you the concepts of OutSystems and how to build applications in Service Studio.
https://www.outsystems.com/training/
https://www.outsystems.com/training/paths/18/becoming-a-reactive-web-developer/
And one of the lessons in the above guided path is: https://www.outsystems.com/training/courses/123/modeling-data/?LearningPathId=18
A part of that course is that you will create a data model (entities with attributes) that OutSystems will use to create the database tables for you.
So long story short: In OutSystems you create entities, and OutSystems will create automatically the tables. Creating tables in OutSystems using SQL is not possible.
Kind regards,
Got it. I've completed the Traditional Web Developer course and that is the next one. In between i've been learning SQL, hence my previous questions. I've been told it is useful to work with OutSystems.
Thanks for all the help!
I'd you completed the traditional web guided path, than there you learned how to create entities.
Hi Daniel,
Yes, through Service Studio i already know. I was trying to do the same via SQL.