3
Reply

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

19y
4.1k
0
Reply

    Hi Ranjana

    Thats right

    19y
    0
    sp_help tablename
    19y
    0
    Ranjana Goel
    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
    19y
    0
Message