How can we fetch the fieldnames in a table using SQL query in SQL Server?
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