Home Forums SQL Server 7,2000 General How Can I Get a List of the Fields in a Table? RE: How Can I Get a List of the Fields in a Table?
Lashams
Ten Centuries
Points: 1026
More actions
January 28, 2004 at 11:58 am
#492046
In Query Analyser type Exec SP_Help tablename . You may have problems if your owner is not DBO, as SP_Help does not let you prefix the table name with an owner. If this is the case you need to log on as the owner I believe to overcome this.