Thread: create tables using the application metadata
Hi All,
I've metadata tables of our application where we have all tables,columns and constraints information about each table stored.
How do I generate the CREATE TABLE sql scripts to generate schema using our application metadata table?
Regards,
Nikhil
Hello Nikhil,
Could you explain with some example data? I can't comment on it without knowing what you have in the metadata table and its structure?
You basically can use SELECT statement and create a string through SQL queries against to your metadata table.
Best regards.
Samed YILDIRIM
Samed YILDIRIM
On Fri, 28 Oct 2022, 09:44 Nikhil Ingale, <niks.bgm@gmail.com> wrote:
Hi All,I've metadata tables of our application where we have all tables,columns and constraints information about each table stored.How do I generate the CREATE TABLE sql scripts to generate schema using our application metadata table?Regards,Nikhil
On 10/28/22 02:43, Nikhil Ingale wrote: > Hi All, > I've metadata tables of our application where we have all tables,columns > and constraints information about each table stored. > > How do I generate the CREATE TABLE sql scripts to generate schema using > our application metadata table? Depending on how your metadata tables are organized, use either the format() function embedded in a SELECT statement, or have your application generate dynamic SQL. -- Angular momentum makes the world go 'round.