Create SQL script that creates 1 new table from 2 existing tables, including all PK, FK, constraints, indexes, etc.
$30-100 USD
In Progress
Posted about 11 years ago
$30-100 USD
Paid on delivery
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.