468,242 Members | 1,459 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,242 developers. It's quick & easy.

export table defination

232 100+
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
1 1598
ck9663
2,878 Expert 2GB
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.

Similar topics

8 posts views Thread by scl | last post: by
3 posts views Thread by nologin | last post: by
25 posts views Thread by venky | last post: by
6 posts views Thread by jefftyzzer | last post: by
5 posts views Thread by situ | last post: by
3 posts views Thread by Edward Reid | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by kermitthefrogpy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.