COLUMNS

[ALEX S]

HI
CAN SOMEONE TELL ME HOW TO GET A LIST OF JUST COLUMNS FOR A SPECIFIED TABLE
LET SAY I HAVE A TABLE AND I WANT TO RETREIVE COLUMNS.
SP_ HELP GIVES A WHOLE LOT BUT I JUST WANT THE COLUMNS.
IS THERE A SPECIAL TABLE THAT HAS COLUMNS LISTED FOR EACH TABLE?



THANKS IN ADVANCE.

[Ray Miao]

On 12/7/98 9:56:14 AM, ALEX S wrote:
> HI
CAN SOMEONE TELL ME HOW TO GET A LIST OF JUST COLUMNS FOR A SPECIFIED
> TABLE
LET SAY I HAVE A TABLE AND I WANT TO RETREIVE COLUMNS.
SP_ HELP
> GIVES A WHOLE LOT BUT I JUST WANT THE COLUMNS.
IS THERE A SPECIAL TABLE
> THAT HAS COLUMNS LISTED FOR EACH TABLE?



THANKS IN ADVANCE.

Use sp_tables table_name.

[Al Blakey]

I believe you want sp_columns not sp_tables.



On 12/7/98 10:17:23 AM, Ray Miao wrote:
> On 12/7/98 9:56:14 AM, ALEX S wrote:
> HI
CAN SOMEONE TELL ME HOW TO GET
> A LIST OF JUST COLUMNS FOR A SPECIFIED
> TABLE
LET SAY I HAVE A TABLE
> AND I WANT TO RETREIVE COLUMNS.
SP_ HELP
> GIVES A WHOLE LOT BUT I JUST
> WANT THE COLUMNS.
IS THERE A SPECIAL TABLE
> THAT HAS COLUMNS LISTED FOR
> EACH TABLE?



THANKS IN ADVANCE.

Use sp_tables table_name.

[Rajendra]

Hi Alex,
I din't get exactly what u wanted,
but there is a table in every database called
syscolumns
which will have an entry of every column in every table,you can get the
object id of the table and access all the columns of that table from this
syscolumns

hope this will help u

bye
Raj





On 12/7/98 9:56:14 AM, ALEX S wrote:
> HI
CAN SOMEONE TELL ME HOW TO GET A LIST OF JUST COLUMNS FOR A SPECIFIED
> TABLE
LET SAY I HAVE A TABLE AND I WANT TO RETREIVE COLUMNS.
SP_ HELP
> GIVES A WHOLE LOT BUT I JUST WANT THE COLUMNS.
IS THERE A SPECIAL TABLE
> THAT HAS COLUMNS LISTED FOR EACH TABLE?



THANKS IN ADVANCE.

[Peter Christof-Dirry]

I think that's what u want:

SELECT syscolumns.name
FROM syscolumns, sysobjects
WHERE syscolumns.id = sysobjects.id
AND sysobjects.name = 'yourTablename'

Peter