Fetch all Table Names with Column Names and Data types from SQL Server Database

The below script will provide the list of table name along with column names and data types.

SELECT T.Name AS TableName,
Schema_name(T.schema_id) AS SchemaName,
C.Name AS ColumnName,
Ty.Name AS ColumnDataType,
C.is_nullable AS IsNullAble,
C.is_identity AS IsIdentity 
FROM sys.tables T
INNER JOIN sys.columns C
ON T.OBJECT_ID = C.OBJECT_ID
INNER JOIN sys.types Ty
ON C.system_type_id = Ty.system_type_id 
WHERE T.is_ms_shipped = 0 
ORDER BY T.name