Find All User Tables, Columns, DataTypes, and Length
To determine all your user tables, plus their columns, datatypes, and length, type: SELECT DISTINCT SO.Name AS “TableName”, SC.ColID, SC.Name AS “ColumnName”, ST.Name AS “DataType”, SC.Length AS “Length”, SC.Status AS