[dba-SQLServer] Where do I find

sp_columns tablename

also works. Slightly different output.

GK

On 12/6/07, Gary Kjos <garykjos at gmail.com> wrote:
> oops, no Describe in SQL Server. sp_help is a near equivalent though..
>
> SP_Help tablename
>
> GK
>
> On 12/6/07, Gary Kjos <garykjos at gmail.com> wrote:
> > In Oracle it would be DESCRIBE tablename. Be worth a shot in SQL Server
> >
> > On 12/6/07, jwcolby <jwcolby at colbyconsulting.com> wrote:
> > > What would the SQL look like to get a list of all the field names in a
> > > table?  I assume that there are system tables with this stuff but it is kind
> > > of slow poking around trying to find that.
> > >
> > > John W. Colby
> > > Colby Consulting
> > > www.ColbyConsulting.com
> > >
> > > _______________________________________________
> > > dba-SQLServer mailing list
> > > dba-SQLServer at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > > http://www.databaseadvisors.com
> > >
> > >
> >
> >
> > --
> > Gary Kjos
> > garykjos at gmail.com
> >
>
>
> --
> Gary Kjos
> garykjos at gmail.com
>


-- 
Gary Kjos
garykjos at gmail.com