List of Fields

Blackcat

Hey Guys,

is there an easy way to retrieve a list with fields (for a specific table) from the SQL-Server? I found the object table and hoped there would be a field table too, but i found nothing.
](*,)

I hope you can help me.

ndbcs

You can join sys.objects on sys.columns.

Tobias

Blackcat

I'll try that.
thanks