SQL

***  creating the table and insert the details from exiting table ***********

select 
*
into newtablename 
from exitingtablename

*** we can insert the details from exiting table to another table (same structure)

insert into [TempOption_details]
(option_id,option_name,option_

type_id,option_type_name,hotel_id)
select option_id,option_name,option_type_id,option_type_name,hotel_id from option_details where option_type_id !=3