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 Chriss Miller 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
Joined
Mar 30, 2000
Messages
398
Location
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 Question
Need help with SQL query to update a Micros report
Replies
0
Views
867
AM_WG
AM_WG
raphael75
  • Locked
  • Question Question
trying to call Sybase stored procedure with parameters from PHP
Replies
0
Views
515
raphael75
raphael75
baltman
  • Locked
  • Question Question
Precison too large error via Excel/ODBC solution needed
Replies
0
Views
570
baltman
baltman
vzavec
  • Locked
  • Question Question
PowerBuilder to SpatiaLite
Replies
0
Views
415
vzavec
vzavec
djjd47130
  • Locked
  • Question Question
Converting Sybase DB to MSSQL
Replies
1
Views
385
djjd47130
djjd47130

Part and Inventory Search

Sponsor

Back
Top