mibuso.com

Microsoft Business Solutions online community
It is currently Sat May 25, 2013 8:54 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: List of Fields
PostPosted: Fri Dec 30, 2011 11:10 am 
Offline

Joined: Sat Apr 19, 2008 10:51 am
Posts: 21
Location: Germany
Country: Germany (de)
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.


Top
 Profile  
 
 Post subject: Re: List of Fields
PostPosted: Fri Dec 30, 2011 12:16 pm 
Offline

Joined: Fri Sep 30, 2011 9:14 pm
Posts: 17
Country: Germany (de)
You can join sys.objects on sys.columns.

Tobias


Top
 Profile E-mail  
 
 Post subject: Re: List of Fields
PostPosted: Fri Dec 30, 2011 2:51 pm 
Offline

Joined: Sat Apr 19, 2008 10:51 am
Posts: 21
Location: Germany
Country: Germany (de)
I'll try that.
thanks :D


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: