How can see code in SQL Server?

If you are in SQL Management Studio you can generate a create statement by right-clicking the table -> Script Table as -> CREATE TO -> New Query Editor Window.

Attention! DROP and CREATE will kill all your data in the table