I need an sql which will copy schema of a specified table to a table
in different db.

How to implement this?

Please help.

The question is perhaps not well written, but it's plainly on topic. There's a lot of voting and answering activity, and it has an accepted answer. None of the answers show any confusion as to what the question is about.

If a question deserves to be closed then vote to close it. Do not answer it.

By choosing to answer you're putting yourself at a risk of having your answer downvoted and deleted. Off-topic questions which fall in the -off-topic- category in the help-centre are simply OFF-TOPIC... they need to be downvoted, closed and deleted not answered.

BTW.

According to the help-centre this question still, is off-topic as per no. 3

3. Questions asking for code must demonstrate a minimal understanding of the problem being solved. Include attempted solutions, why they didn't work, and the expected results. See also: Stack Overflow question checklist.

Or you may have forgotten the fact that the question was answered almost 5 years ago, at which time it was perfectly on topic. Claiming that the OP chose to answer a question that deserves to be closed and thus put himself at risk for rep-whoring is a bit of a stretch here.
–
AntonyJun 24 '14 at 7:47

1

I was not sure how anyone could categorise this as off-topic. The questioner is clearly aware of what he wants to do: copy a table schema. Asking for "attempted results" or example output would not at all improve the question. But I guess from your answer it has something to do with the questioner being judged unworthy of repution?
–
AndomarJun 24 '14 at 7:50

9

It does not matter when the question was asked or answered. If it's off-topic today then we vote to close it as off-topic. This is exactly why this site stays up to date and is much easier to navigate through than any other site because it's moderated and 90% of useless junk at some point does get deleted.
–
MeehowJun 24 '14 at 7:50

"Note that it have no delete votes - so will not magically disappear" BOOM meta effect ;)
–
OGHazaJun 24 '14 at 8:16

1

For me it already meets the quality standards. It's certainly better than half of new questions I see in the SQL tag today. This one is fairly typical. None of these questions gets closed or deleted.
–
AndomarJun 24 '14 at 9:24

2

@Andomar Consider re-learning what the quality standards are then - the question you're talking about doesn't even come close to being good enough for SO (btw the "typical" question you linked to in your previous comment was deleted within 15 minutes...)
–
CliveJun 24 '14 at 10:00

@Clive: I guess nowadays people ask for a lot of formalities, like formatting, a lengthy body in proper English, thought out titles, no "pleae help" notes, and so on. But materially this question is fine.
–
AndomarJun 24 '14 at 13:08

1

Nope. What you call 'formalities' are what we call 'requirements for an acceptable question'. Please familiarise yourself with all the literature in the help center on Stack Overflow to understand what's wrong with that question, there's far too much wrong to explain in a single comment (and since the information is already easily accessible I'm reluctant to repeat it for you here)
–
CliveJun 24 '14 at 13:33

Close, but not delete

I completely agree with closing the question, but deletion is a different thing. The question had 6 answers, 5 of them upvoted. Having deleted the question, we have deleted the answers, too, and if upvotes indicate merit to any extent, we have deleted valuable content.