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?

www.com | www.net | www.org
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?