Indices
Help
 Archive Intro
 Table Descriptions
 Schema Browser
 Glossary
 Algorithms
 Introduction to SQL
 Form Query User Guide
 Query Limits
 How To
 FAQ
 API
 sdssQA
 Download
 SkyServer Sites
 Web Browsers
 Contact Help Desk

Table NameIndex TypeKey or Field List
Best2Sector primary keyobjid, regionID
Best2Sector foreign keyPhotoObjAll(objID)
Best2Sector foreign keySector(regionID)
Best2Sector covering unique indexregionID, objid
Chunk primary keychunkID
Chunk foreign keyStripeDefs(stripe)
Convex primary keyregionid, convexid, constraintid
Convex foreign keyRegion(regionid)
DataConstants primary keyfield, name
DataConstants covering indexvalue
DBColumns primary keytableName, name
DBColumns foreign keyDBObjects(name)
DBObjectDescription primary keyname
DBObjectDescription foreign keyDBObjects(name)
DBObjects primary keyname
DBViewCols primary keyviewName, name
DBViewCols foreign keyDBObjects(name)
Diagnostics primary keyname
ELRedShift primary keyelRedShiftID
ELRedshift foreign keySpecObjAll(specObjID)
ELRedShift covering unique indexspecObjID, elRedShiftID
Field primary keyfieldID
Field foreign keySegment(segmentID)
Field covering indexfield, camcol, run, rerun
Field covering indexrun, camcol, field, rerun
FieldProfile primary keyfieldID, bin, band
FieldProfile foreign keyField(fieldID)
FileGroupMap primary keytableName
FileGroupMap foreign keyPartitionMap(fileGroupName)
First primary keyobjID
First foreign keyPhotoObjAll(objID)
Frame primary keyfieldID, zoom
Frame foreign keyField(fieldID)
Frame covering indexfield, camcol, run, zoom, rerun
Frame covering indexhtmID, zoom, cx, cy, cz, a, b, c, d, e, f, node, incl
Glossary primary key[key]
History primary keyversion
HoleObj primary keyHoleID
HoleObj foreign keyPlateX(plateID)
IndexMap primary keyindexmapid
IndexMap foreign keyDBObjects(name)
LoadHistory primary keyloadVersion, tStart
Mask primary keymaskID
Mask covering indexhtmID, ra, dec, cx, cy, cz
MaskedObject primary keyobjid, maskid
MaskedObject foreign keyPhotoObjAll(objID)
MaskedObject foreign keyMask(maskID)
Match primary keyobjID, matchObjID
Match foreign keyPhotoObjAll(objID)
MatchHead primary keyobjID
MatchHead foreign keyPhotoObjAll(objID)
Neighbors primary keyobjID, NeighborObjID
Neighbors foreign keyPhotoObjAll(objID)
ObjMask primary keyobjID
ObjMask foreign keyPhotoObjAll(objID)
PartitionMap primary keyfileGroupName
PhotoObjAll primary keyobjID
PhotoObjAll foreign keyField(fieldID)
PhotoObjAll covering indexmode, cy, cx, cz, htmID, type, flags, status, ra, dec, u, g, r, i, z, rho
PhotoObjAll covering indexhtmID, cx, cy, cz, type, mode, flags, status, ra, dec, u, g, r, i, z, rho
PhotoObjAll covering indexfield, run, rerun, camcol, type, mode, flags, rowc, colc, ra, dec, u, g, r, i, z
PhotoObjAll covering indexfieldID, objID, ra, dec, r, type, status, flags
PhotoObjAll covering indexSpecObjID, cx, cy, cz, mode, type, flags, status, ra, dec, u, g, r, i, z, rho
PhotoObjAll covering indexcx, cy, cz, htmID, mode, type, flags, status, ra, dec, u, g, r, i, z, rho
PhotoObjAll covering indexrun, mode, type, status, flags, u, g, r, i, z, Err_u, Err_g, Err_r, Err_i, Err_z
PhotoObjAll covering indexrun, camcol, rerun, type, mode, status, flags, ra, dec, fieldID, field, u, g, r, i, z
PhotoObjAll covering indexrun, camcol, field, mode, parentID, q_r, q_g, u_r, u_g, isoA_r, isoB_r, fiberMag_u, fiberMag_g, fiberMag_r, fiberMag_i, fiberMag_z
PhotoProfile primary keyobjID, bin, band
PhotoProfile foreign keyPhotoObjAll(objID)
PhotoTag primary keyobjID
PhotoTag foreign keyPhotoObjAll(objID)
PhotoTag foreign keyField(fieldID)
PhotoTag covering indexmode, cy, cx, cz, htmID, type, flags, status, ra, [dec], modelMag_u, modelMag_g, modelMag_r, modelMag_i, modelMag_z, [size]
PhotoTag covering indexhtmID, cx, cy, cz, type, mode, flags, status, ra, [dec], modelMag_u, modelMag_g, modelMag_r, modelMag_i, modelMag_z, [size]
PhotoTag covering indexfield, run, rerun, camcol, type, mode, flags, ra, [dec], modelMag_u, modelMag_g, modelMag_r, modelMag_i, modelMag_z
PhotoTag covering indexfieldID, objID, ra, [dec], modelMag_r, type, status, flags
PhotoTag covering indexSpecObjID, cx, cy, cz, mode, type, flags, status, ra, [dec], modelMag_u, modelMag_g, modelMag_r, modelMag_i, modelMag_z, [size]
PhotoTag covering indexcx, cy, cz, htmID, mode, type, flags, status, ra, [dec], modelMag_u, modelMag_g, modelMag_r, modelMag_i, modelMag_z, [size]
PhotoTag covering indexrun, mode, type, status, flags, modelMag_u, modelMag_g, modelMag_r, modelMag_i, modelMag_z, modelMagErr_u, modelMagErr_g, modelMagErr_r, modelMagErr_i, modelMagErr_z
PhotoTag covering indexrun, camcol, field, rerun, type, mode, status, flags, ra, [dec], fieldID, modelMag_u, modelMag_g, modelMag_r, modelMag_i, modelMag_z
Photoz primary keyobjID, rank, pId
Photoz foreign keyPhotoObjAll(objID)
PlateX primary keyplateID
PlateX covering indexhtmID, ra, dec, cx, cy, cz
ProfileDefs primary keybin
QsoCatalogAll primary keyzone, ra, SpecObjID, bestObjID, targetObjID
QsoConcordance primary keyzone, ra, dec, specObjID, bestObjID, targetObjID
Region primary keyregionid
Rmatrix primary keymode, row
Rosat primary keyobjID
Rosat foreign keyPhotoObjAll(objID)
SDSSConstants primary keyname
Sector primary keyregionId
Sector foreign keyRegion(regionID)
Sector2Tile primary keyregionId, tile
Sector2Tile foreign keySector(regionID)
Sector2Tile foreign keyTileAll(tile)
Sector2Tile covering unique indextile, regionID
Segment primary keysegmentID
Segment foreign keyChunk(chunkId)
Segment foreign keyStripeDefs(stripe)
SiteConstants primary keyname
SiteDiagnostics primary keyname
SpecLineAll primary keyspecLineID
SpecLineAll foreign keySpecObjAll(specObjID)
SpecLineAll covering unique indexspecobjID, specLineID
SpecLineIndex primary keyspecLineIndexID
SpecLineIndex foreign keySpecObjAll(specObjID)
SpecLineIndex covering unique indexspecobjID, speclineindexID
SpecObjAll primary keyspecObjID
SpecObjAll foreign keyPlateX(plateID)
SpecObjAll covering indexhtmID, ra, dec, cx, cy, cz, sciencePrimary
SpecObjAll covering indexBestObjID, objType, objTypeName, sciencePrimary, specClass, htmID, ra, dec, fiberMag_u, fiberMag_g, fiberMag_r, fiberMag_i, fiberMag_z
SpecObjAll covering indexspecClass, zStatus, zWarning, z, sciencePrimary, primTarget, secTarget, plateId, bestObjID, targetObjId, htmID, ra, dec
SpecObjAll covering indextargetObjID, objType, objTypeName, sciencePrimary, specClass, htmID, ra, dec, fiberMag_u, fiberMag_g, fiberMag_r, fiberMag_i, fiberMag_z
SpecPhotoAll primary keyspecObjID
SpecPhotoAll foreign keySpecObjAll(specObjID)
SpecPhotoAll covering indexobjID, sciencePrimary, specClass, z, targetObjid, targetId
SpecPhotoAll covering indextargetObjID, sciencePrimary, specClass, z, objid, targetId
SpecPhotoAll covering indextargetID, sciencePrimary, specClass, z, objid, targetObjId
StripeDefs primary keystripe
Target primary keytargetID
Target covering indexbestobjID, regionID, specobjid
Target covering indexspecobjID, regionID, bestobjID
Target covering indexregionID, bestobjid, specobjid
Target covering indexhtmID, ra, dec, cx, cy, cz
TargetInfo primary keyskyVersion, targetID
TargetInfo foreign keyTarget(targetID)
TargetInfo covering indextargetobjID, primTarget, secTarget, priority
TargetInfo covering unique indextargetID, skyversion, targetobjID
TargetParam primary keytargetVersion, name
TileAll primary keytile
TileAll foreign keyTilingRun(tileRun)
TileAll covering unique indextileRun, tile
TileAll covering indexhtmID, racen, deccen, cx, cy, cz
TiledTargetAll primary keytargetID, tile
TiledTargetAll foreign keyTileAll(tile)
TiledTargetAll covering unique indextile, targetID
TiledTargetAll covering indexhtmID, ra, dec, cx, cy, cz, objtype
TiledTargetAll covering unique indexobjType, targetID, tile
TilingGeometry primary keytilingGeometryID
TilingGeometry foreign keyTilingRun(tileRun)
TilingGeometry foreign keyStripeDefs(stripe)
TilingInfo primary keytileRun, targetID
TilingInfo foreign keyTilingRun(tileRun)
TilingInfo covering unique indextargetID, tileRun, collisionGroupID
TilingInfo covering unique indextileRun, collisionGroupID, targetID
TilingInfo covering indextile, collisionGroupID
TilingNote primary keytilingNoteID
TilingNote foreign keyTilingRun(tileRun)
TilingRun primary keytileRun
USNO primary keyobjID
USNO foreign keyPhotoObjAll(objID)
XCRedshift primary keyxcRedshiftID
XCRedshift foreign keySpecObjAll(specObjID)
XCRedshift covering unique indexspecObjID, xcRedShiftID
Zone primary keyzoneID, ra, objID
Zone foreign keyPhotoObjAll(objID)