SQL Tricks
add to favorites
|
RSS
A trail of 1 page, marked with comments, by
etylocus
About this trail:
create table duplicate as select * from original_table where 1 = 2
Trail link:
http://www.trailfire.com/etylocus/trails/14058
Summary:
http://www.trailfire.com/etylocus/trailview/14058
0
0
35 views
1 mark in this trail
Tags
answered
aspx
brett
create
creating
data
development
duplicate
fast
forums
http
kingdom
kristen
madhivanan
newtable
number
oldtable
original
posted
posts
questions
script
select
server
sql
table
topic
tricks
usa
weblogs
yak
Similar Trails
MyTrail
(by
renil
)
SQL Server 2005
(by
renil
)
Learn SQL with Oracle
(by
frank
)
SQL
(by
TonySayz
)
Mysql
(by
floweringmind
)
SQL
(by
jenny
)
jgools's Trail
(by
jgools
)
Database Encryption
(by
ewujian
)
program.sql
(by
enjoylife
)
Microsoft SQL Server Hosting : syntax
(by
bestcoupon
)
1
How to duplicate a table in SQL Server
create table duplicate as select * from original_table where 1 = 2
View mark summary
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=53294
0 comments on this Trail
Add your comment:
Share this trail
Let non-users see the trail with this URL:
Email it
Anyone can see the trail with this URL:
Email it
Visible
Editable
Everyone
Your contacts
Trailfire
Save
[edit your contacts]
Let non-users see the trail with this URL:
Email it
Join Trailfire
Sign In...
Username:
Password:
Sign In
Forgot Password?
Learn More
Download
My Stuff
Explore