Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

quick way to see

Status
Not open for further replies.
babeo

babeo

Technical User
Mar 30, 2000
398
CA
Hi

Is there a quick way to see all the field names of a table?
Thanks
 
Sort by date Sort by votes
You can either use a simple:
select * from [table_name] where 1=2

or also

sp_help [table_name]

Regards,
Roberto
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

AM_WG
  • Locked
  • Question
Need help with SQL query to update a Micros report
Replies
0
Views
166
AM_WG
AM_WG
raphael75
  • Locked
  • Question
trying to call Sybase stored procedure with parameters from PHP
Replies
0
Views
120
raphael75
raphael75
baltman
  • Locked
  • Question
Precison too large error via Excel/ODBC solution needed
Replies
0
Views
124
baltman
baltman
vzavec
  • Locked
  • Question
PowerBuilder to SpatiaLite
Replies
0
Views
100
vzavec
vzavec
djjd47130
  • Locked
  • Question
Converting Sybase DB to MSSQL
Replies
1
Views
63
djjd47130
djjd47130

Part and Inventory Search

Sponsor

Back
Top