MSSQL equivalent for SHOW CREATE TABLE

[jamesm6162]

Hi

I need to convert MySQL code to MSSQL in a php script.

What is the MSSQL syntax for SHOW CREATE TABLE?

Thanks

[chazzy]

I don't believe that there's an automatic way to get the entire create table structure from a single command. You'll likely need to query against sysobjects to find the appropriate columns.

[jamesm6162]

OK thanks man.

I rewrote the part of the script to get a workaround, so I did fix the problem in the end.

[viljun]

Had similar problem. Is this what you need:

Sql server show create table (http://www.varuste.net/show_create_table.html)

Yours,
Ville