-
COLUMNS
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.
-
COLUMNS (reply)
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.
-
COLUMNS (reply)
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.
-
COLUMNS (reply)
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.
-
COLUMNS (reply)
I think that's what u want:
SELECT syscolumns.name
FROM syscolumns, sysobjects
WHERE syscolumns.id = sysobjects.id
AND sysobjects.name = 'yourTablename'
Peter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|