Right CLick on database

-Tasks

-Generate Scripts

-select a database

-Choose script options

(select the script data option set to true)

-and proceed further....

finally you can have the table structure coding along with the data.

(These steps for sql server 2008...you may use this tips for other version)

D. Kumaresh