Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

Re: What is similar in mssql to $dbh->listfields($tbl) in mysql

by gellyfish (Monsignor)
on Oct 24, 2006 at 11:53 UTC ( #580248=note: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download


  1. or download this
    select syscolumns.name from syscolumns
    join sysobjects on sysobjects.id = syscolumns.id
    where sysobjects.name = ?
    
  2. or download this
    select COLUMN_NAME from information_schema.columns
    where table_name = ?
    

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://580248]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others browsing the Monastery: (2)
As of 2022-05-17 01:10 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Do you prefer to work remotely?



    Results (65 votes). Check out past polls.

    Notices?