RadhaKrishnaKiJaya
asked on
Create column definitions of a table into another table
Hello Experts,
I am trying to create table which should contain Column Name, Data Type and Length from another Table. Please see the example below:
Table - 1(Employee): Record Count (10)
-------------------------- ---------- ---------- ---------- -
1. Employee_Name Varchar(50)
2. DateOfBirth Date
3. Salary Int
4. Active char(1)
Table - 2 (Temp)
--------------------------
1. Column_Name - any text data type say Varchar(50)
2. Data_Type - any text data type say Varchar(20)
3. Length - any int data type say Int
Data (in Table -2)
-------------------------- -
Employee_Name, Varchar, 50
DateOfBirth, Date, 8
Salary, Int, 10,2
Active, Char, 1
Basically I am just getting the structure from Table-1 in Table-2 in the form of columns. Please let me know if this something possible.
Thank you in advance.
Thank you.
I am trying to create table which should contain Column Name, Data Type and Length from another Table. Please see the example below:
Table - 1(Employee): Record Count (10)
--------------------------
1. Employee_Name Varchar(50)
2. DateOfBirth Date
3. Salary Int
4. Active char(1)
Table - 2 (Temp)
--------------------------
1. Column_Name - any text data type say Varchar(50)
2. Data_Type - any text data type say Varchar(20)
3. Length - any int data type say Int
Data (in Table -2)
--------------------------
Employee_Name, Varchar, 50
DateOfBirth, Date, 8
Salary, Int, 10,2
Active, Char, 1
Basically I am just getting the structure from Table-1 in Table-2 in the form of columns. Please let me know if this something possible.
Thank you in advance.
Thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER