SQL... SQL... SQL
Chee Chong Hwa aka CCH, a Malaysian Chief Software Architect blogs on the usage of SQL and Databases
Showing posts with label
TABLE
.
Show all posts
Showing posts with label
TABLE
.
Show all posts
Thursday, April 30, 2009
How to copy a table ?
Make a copy of an existing table
SELECT * INTO
TargetTable
FROM
SourceTable
Make a copy of the structure of an existing table
SELECT * INTO
TargetTable
FROM
SourceTable
WHERE
1=0
Home
Subscribe to:
Posts (Atom)