Create SQL script that creates 1 new table from 2 existing tables, including all PK, FK, constraints, indexes, etc.

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.