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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
how do i create a copy of a table 1
- Thread starter 2314
- Start date
-
1
- #2
RobertT687
Programmer
SELECT *
INTO copyofyourtable
FROM originaltable
Note: Tis does NOT recreate any keys or indexes. It just copies the structure and data.
INTO copyofyourtable
FROM originaltable
Note: Tis does NOT recreate any keys or indexes. It just copies the structure and data.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question