Skip to content
Advertisement

Show create table tablename in SQL Server

In MySQL it is possible to do show create table tablename

What is the SQL Server equivalent?

Advertisement

Answer

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.

User contributions licensed under: CC BY-SA
1 People found this is helpful
Advertisement