Generate Table Create Scripts using Stored Procedure

 I need a stored procedure which can generate table create script as output
For example:


                   Let us assume the name of the stored procedure as GenerateSP, then while executing " GenerateSP 'TableName' ". The output must be the create query of 'TableName'. Thank you


...