How to use a statement in an SQL query to query the column names and data types (including type and length) of a table

Select A.name as table name, b.name as column name, c.name as type, b.max_length as Byte count, b.precision As Integer, B.scale as decimal from Sys.tables a INNER JOIN Sys.columns B on a.object_id=b.object_id inner join Sys. Types C on c.user_type_id=b.user_type_id

This article is from the "IT" blog, so be sure to keep this source http://8577754.blog.51cto.com/8567754/1553205

How to use a statement in an SQL query to query the column names and data types (including type and length) of a table