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.