Hi Ranjana

Thats right

sp_help tablename

Hi Bino B SELECT column_name, Data_type,CHARACTER_MAXIMUM_LENGTH,IS_NULLABLE FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name='tablename' Replace tablename with the name of your table