C# Tutorials and offshore development in India

Prizes & Awards

My Profile

AdSense Revenue

Active Members
Today

Abhi (38)
divya (34)
Babu Akkandi (28)

Last 7 Days

more...

New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !

Copy Structure of a Table to a New Table

Posted Date: 24 May 2008	Resource Type: Code Snippets	Category: SQL
Author: NP Senthil kumar	Member Level: Gold
Rating:	Points: 10

Hi,
The following query copies the structure of the table but not the data

Select * into NewTable from OldTable where 1=2

Responses

Author: Kapil Dhawan 17 Jun 2008

Member Level: Gold Points : 2

Hello
Nice piece of code
Thanks for sharing your knowledge with us.
I hope to see more good code from your side
This code will help lots of guys
Thanks to you
Regards,
Kapil

Author: Bunty 27 Jun 2008

Member Level: Diamond Points : 2

Hi,

Nice piece of code.

Short and simple to understand.

Keep posting such useful code.

Thanks for sharing your knowledge.

Thanks and Regards
S.S.Bajoria

Author: Anjali Sharma 30 Jun 2008

Member Level: Gold Points : 1

hi
nice code
its raelly wrking
keep on postiong these useful code

Feedbacks

Popular Tags

What are tags ?

Search Tags

(No tags found.)

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: How to use Case in SQL
	Previous Resource: How to see the Particular Stored Procedure Details
	Return to Discussion Resource Index
	Post New Resource
	Category: SQL

Post resources and earn money!

Related Resources

dotNet Slackers BizTalk Adaptors Web Design