If it's SQL 2005, open your Management Studio. Open your Object Explorer Detail window. Click on Tables. Just like Windows Explorer, select all tables that you want to backup. Right-click, Script table as, Create to, New Query Window.
Copy the code on your query window, open a text editor, paste everything.
Happy coding!
-- CK
Hello,
The above solution takes a lot of time if if u have many tables..
And if u take many databases , then this process will take a lot of time.
Can u give a command or procedure, which automatically takes the backup of all the structures in the database
With regards,
winsletmathew