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