Gary Kjos
garykjos at gmail.com
Thu Dec 6 14:05:43 CST 2007
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