File / table description.

[MF]

Newby question but can't find it myself.

How can I get a file-description from a file / table ?

eg. the decription must deliver the following info:

Record nr.
Field nr.
Fieldname
Field description
Data type
Lenght
Decimals

etc....

Can somebody please tell me what to do?

Thanx
MF

[Madhivanan]

Is this?

Select * from information_sch ema.columns where table_name='you rTable'

Madhivanan

[MF]

Madhivanan wrote:

Is this?

Select * from information_sch ema.columns where table_name='you rTable'

Madhivanan

Doesn't work, but thanx for the response.

[Simon Hayes]

You'll probably have to combine a few different things to get those
details - check out sysobjects, syscolumns, object_name(),
objectproperty( ), columnproperty( ) and fn_listextended property() in
Books Online. You could also have a look at the source for sp_help,
which returns most of the items you're interested in.

If you can't work out what you're looking for, I suggest you post a
simple CREATE TABLE statement (or perhaps use to a table in the pubs
database as an example), and show what your desired output would look
like for that table - that will probably be clearer than a description.
You might also want to clarify why Madhivanan's suggestion didn't work
for you.

Simon

[Erland Sommarskog]

Madhivanan (ma************ @gmail.com) writes:

Is this?

Select * from information_sch ema.columns where table_name='you rTable'

Select * from INFORMATION_SCH EMA.COLUMNS where TABLE_NAME='you rTable'

This matter with a case-sensitive collation. And the names in
INFORMATION_SCH EMA is all in uppercase.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

[MF]

Thanx a lot all of you. I was looking in the Master db for these files,
combining them will be difficult but I'll give it a try.

TY
Simon Hayes wrote:

You'll probably have to combine a few different things to get those
details - check out sysobjects, syscolumns, object_name(),
objectproperty( ), columnproperty( ) and fn_listextended property() in
Books Online. You could also have a look at the source for sp_help,
which returns most of the items you're interested in.

If you can't work out what you're looking for, I suggest you post a
simple CREATE TABLE statement (or perhaps use to a table in the pubs
database as an example), and show what your desired output would look
like for that table - that will probably be clearer than a description.
You might also want to clarify why Madhivanan's suggestion didn't work
for you.

Simon