Equivalent of sp_helptext for tables in SQL Server

Question

When we need the query of stored procedures we use 'Sp_Helptext procedurename'

Can something similar be done for tables?

Answer 1

There does not appear to be a direct equivalent of sp_helptext that will work with tables.

The two methods that seem to be common on various message boards are:

1. Use Information_Schema.Columns and concatenate the results into the create statement.
2. Use SQL-DMO script

There is an article on the second method here

Answer 2

Please use followig query

select * from information_Schema.columns where table_name = 'TableName'