export table defination

[kkshansid]

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

[ck9663]

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