SQL: Exec sp_columns @table_name='User'

query
  CHAR_OCTET_LENGTH COLUMN_DEF COLUMN_NAME DATA_TYPE IS_NULLABLE LENGTH NULLABLE ORDINAL_POSITION PRECISION RADIX REMARKS SCALE SQL_DATA_TYPE SQL_DATETIME_SUB SS_DATA_TYPE TABLE_NAME TABLE_OWNER TABLE_QUALIFIER TYPE_NAME
1 [empty string] [empty string] UserID 4 NO 4 0 1 10 10 [empty string] 0 4 [empty string] 56 User dbo silverwareconsultingdb int identity
2 50 [empty string] UserName 12 NO 50 0 2 50 [empty string] [empty string] [empty string] 12 [empty string] 39 User dbo silverwareconsultingdb varchar
3 100 [empty string] Email 12 NO 100 0 3 100 [empty string] [empty string] [empty string] 12 [empty string] 39 User dbo silverwareconsultingdb varchar
4 50 [empty string] Phone 12 YES 50 1 4 50 [empty string] [empty string] [empty string] 12 [empty string] 39 User dbo silverwareconsultingdb varchar
5 50 [empty string] Password 12 NO 50 0 5 50 [empty string] [empty string] [empty string] 12 [empty string] 39 User dbo silverwareconsultingdb varchar
6 2147483647 [empty string] UserDetails -1 YES 2147483647 1 6 2147483647 [empty string] [empty string] [empty string] -1 [empty string] 35 User dbo silverwareconsultingdb text
7 [empty string] [empty string] StartDate 11 YES 16 1 7 23 [empty string] [empty string] 3 9 3 111 User dbo silverwareconsultingdb datetime
8 [empty string] [empty string] WalletContents 3 NO 21 0 8 19 10 [empty string] 4 3 [empty string] 60 User dbo silverwareconsultingdb money
9 [empty string] [empty string] UserTypeID 4 NO 4 0 9 10 10 [empty string] 0 4 [empty string] 56 User dbo silverwareconsultingdb int
10 [empty string] [empty string] ActiveFlag -7 NO 1 0 10 1 [empty string] [empty string] 0 -7 [empty string] 50 User dbo silverwareconsultingdb bit