SHOW CREATE TABLE in SqlServer
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)