Share the joy
In Oracle, we can easily get the DDL clause. In mysql, we can use SHOW CREATE TABLE.
In SqlServer, there is no similar command. However, we can get data type by below command:
SELECT name, system_type_name, is_nullable FROM
sys.dm_exec_describe_first_result_set(‘SELECT * FROM table‘, NULL, 0)