If you just want the creation statement, management studio can generated it based on the system tables. From object explorer right click the table, script as -> create

If you want to see the exact statement that was run, you need either a DDL trigger or a trace running at the time the statement was executed.

As for example, why don't you open the documentation and have a look? Quicker than asking here.

http://msdn.microsoft.com/en-us/library/ms189799%28v=SQL.90%29.aspx

http://msdn.microsoft.com/en-us/library/ms186406%28v=SQL.90%29.aspx

http://msdn.microsoft.com/en-us/library/ms175941%28v=SQL.90%29.aspx