[dba-SQLServer] Where do I find

Gary Kjos garykjos at gmail.com
Thu Dec 6 14:11:14 CST 2007


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



More information about the dba-SQLServer mailing list