I used to list from sysobjects to get this information, but found the INFORMATION_SCHEMA is a lot easier.
2001-08-22
729 reads
Column names, data types, and lengths
select
TABLE_NAME,
ORDINAL_POSITION 'Col No',
substring(rtrim(COLUMN_NAME),1,25) 'Column Name',
substring(DATA_TYPE + case when DATA_TYPE like '%char%' then '(' +
rtrim(convert(char(3),CHARACTER_MAXIMUM_LENGTH)) + ')' else '' end,1,25) 'DataType'
from INFORMATION_SCHEMA.COLUMNS
order by ORDINAL_POSITION Related content
2001-08-22
383 reads
hx_ShowFixedDriveSpace
Very simple, how much space is free on the hard drives of the SQL Server you are connected to.
2001-08-22
669 reads
hx_OLEDBproviders
Get OLE Providers info I have found this useful in tracking down application driver/connection issues. I only had to use it 2 times. But it did help
2001-08-22
415 reads
2001-08-22
712 reads