Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
COPY TABLE STUCTURE IN SQL
- Thread starter mabaulza
- Start date
If you just want the columns:
If you need to copy the constraints (PKs, CHECKs etc) then your best bet is to script the old table, either from EM or the QA object browser, edit the object names and execute it.
--James
Code:
SELECT * INTO new_table
FROM old_table
WHERE 1 = 0If you need to copy the constraints (PKs, CHECKs etc) then your best bet is to script the old table, either from EM or the QA object browser, edit the object names and execute it.
--James
- Status
Similar threads
- Locked
- Question
- Question
