Copy structure of all the tables of one database to another server

[Member_14731923]

I want to copy the structure of all the tables of one database from one server to another server by using Stored Procedure ( due to automation ) there should be no index, no trigger , no fkr etc

[phil o]

Nice requirement. You have permission to proceed :)

"Five fruits and vegetables a day? What a joke! Personally, after the third watermelon, I'm full."

[Lost User]

Easiest way to copy the structure is to do a backup, initiated from the sproc. You can restore that on whatever server you want.

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.