By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,842 Members | 2,440 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,842 IT Pros & Developers. It's quick & easy.

export table defination

P: 232
is there any method to export data as well as table defination from sql server ?
i m new to ms sql but its possible in mysql
Dec 1 '08 #1
Share this Question
Share on Google+
1 Reply

Expert 2.5K+
P: 2,878
Two steps.

1. Right-click on your table and you can generate the script as "script as" to a window or clipboard that you can copy.

2. You have to do a BCP or manually export the table.

-- CK
Dec 2 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.