show create table tablename (how do i do this in sql server) ?

Question

in mysql it is possible to do show create table tablename

what is the sql server equivalent?

Answer 1

In SSMS, right-click on the table node and "Script Table As" / "Create".

There is no built in 'script this table' T-SQL.

sp_help 'tablename' gives useful table information if that'd do.