If we execute create sql script of table, does create table in outsystems module
Application Type
Traditional Web, Reactive

Hello Team,

I have sql server database is sync with outsystems database. Instead of creating an entity in outsystems module, can i create table in sql server? Can this table will reflect in outsystems module?

Kindly suggest the best practice for the same.

Hi Pradip,

I think you can't create table in OutSystems by running script. Easiest way is export table as excel from external database and then create entity in OutSystems by importing those excels.

regards

Hi Pradip Chavhan,

You cannot use DDL queries in advanced SQL. Outsystems follows a different way of managing tables (the entity name is not the same as the actual table created in the backend). Please go through the link below

Document Link


Thanks to both of you for the quick reply, i will go through the doc also i will try for excel option. 

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.