|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
How to get the Table Name from the ID column in syscolumnsselect ID from syscolumns
how do I find out what the table name is based on ID? thanks SELECT OBJECT_NAME(id) FROM syscolumns
However, a better place to retrieve this information is INFORMATION_SCHEMA.COLUMNS Show quote "Mator DeSchenna" <ddsdd*sdadf.com> wrote in message news:zOOdnYkgJsShY0rfRVn-iw@comcast.com... > select ID from syscolumns > > how do I find out what the table name is based on ID? > thanks > The function object_id( object_id ) will return the name for any type of
object id (tables, SPs, etc.). Show quote "Mator DeSchenna" <ddsdd*sdadf.com> wrote in message news:zOOdnYkgJsShY0rfRVn-iw@comcast.com... > select ID from syscolumns > > how do I find out what the table name is based on ID? > thanks > but I meant to say.. object_name( object_id )
Show quote "Mator DeSchenna" <ddsdd*sdadf.com> wrote in message news:WoadnZKg3eLelUXfRVn-2A@comcast.com... > Thank you > > > Yes you certainly did
Show quote "JT" <some***@microsoft.com> wrote in message news:OLb4UMXiFHA.1412@TK2MSFTNGP10.phx.gbl... > but I meant to say.. object_name( object_id ) > > "Mator DeSchenna" <ddsdd*sdadf.com> wrote in message > news:WoadnZKg3eLelUXfRVn-2A@comcast.com... >> Thank you >> >> >> > >  |
|||||||||||||||||||||||
Other interesting topics