PHWinfo - Afficher un message

02/04/2008, 20h51

lark wrote:
> ronn2007@hotmail.co.uk wrote:
>> Hi, I know sys.tables and sys.columns gives me a list of tables and
>> columns in a SQL 2005 database.
>>
>> How can I list Columns in a specific Table please?
>>
>> Thanks in advance,
>> Ronny
> desc tablename
scratch that. it doesn't work in ms sqlserver.

02/04/2008, 20h51	#4
lark Messages: n/a Hébergeur:	Re: List Columns in a Table in SQL 2005 lark wrote: > ronn2007@hotmail.co.uk wrote: >> Hi, I know sys.tables and sys.columns gives me a list of tables and >> columns in a SQL 2005 database. >> >> How can I list Columns in a specific Table please? >> >> Thanks in advance, >> Ronny > desc tablename scratch that. it doesn't work in ms sqlserver.