Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

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

by gellyfish (Monsignor)
on Oct 24, 2006 at 11:53 UTC ( [id://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?Last hourOther CB clients
Other Users?
Others meditating upon the Monastery: (4)
As of 2024-03-28 13:21 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found