3
Reply

How can we fetch the fieldnames in a table using SQL query in SQL Server?

Jul 26, 2006
4.1k
0

    Hi Ranjana

    Thats right

    July 26, 2006
    0

    sp_help tablename

    July 26, 2006
    0

    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

    Ranjana Goel
    July 26, 2006
    0