- select * from information_schema.columns where table_name='tbl_emp'
or
- sp_columns tbl_emp
Get Table Information with Column Datatype in SQL
This code for get Table information with column data type in sql server.
Loading
This code for get Table information with column data type in sql server.