3
Reply

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

20y
4.1k
0
Reply

    Hi Ranjana

    Thats right

    20y
    0
    sp_help tablename
    20y
    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
    20y
    0
Message