Create SQL script (stored procedure) that creates 1 new table from 2 existing tables, including all PK, FK, constraints, indexes, etc.
Example: Table a has columns id,a1,a2
Table b has columns id,b1,b2,b3
The procedure will receive 3 table names (a and b - for input, c - for output) and will create table c with columns id,a1,a2,b1,b2,b3, including all existing data of two input tables - constraints, PKs, FKs, indexes, etc.
Remark: First column of tables a and b (meaning column id) is the only column with the same name.
5 freelancer bu iş için ortalamada 37$ teklif veriyor
Sir, Ready to write SQL script to create new table with constraints. I am looking forward to hear from you. Thanking you [url removed, login to view]