how to get table_definition in sqlserver TSQL

See more:

SQL-Server

Hi all,

I execute this query in sqlserver

SELECT * FROM INFORMATION_SCHEMA.views

which returns me

view_definition
"CREATE view v1  as  (select TABLE_name, COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS)"

is there any query like this which returns me Table_definition

create table tablename
(
id numeric,
fname nvarchar(50)
 
)