| name | description |
| DataConstants | The table is storing various enumerated constants for flags, etc |
| SDSSConstants | This table contains most relevant survey constants and their physical units |
| StripeDefs | This table contains the definitions of the survey layout as planned |
| RunShift | The table contains values of the various manual nu shifts for runs |
| ProfileDefs | This table contains the radii for the Profiles table |
| Frame | Contains JPEG images of fields at various zoom factors, and their astrometry. |
| QueryResults | Store the results of performance tests here |
| SiteConstants | Table holding site specific constants |
| Glossary | Contains a paragraph of text for each keyword in the Glossary |
| Algorithm | Contains a paragraph of text for each algorithm |
| TableDesc | Contains a paragraph of description for each table in the DB |
| DBObjects | Every SkyServer database object has a one line description in this table |
| DBColumns | Every column of every table has a description in this table |
| DBViewCols | The columns of each view are stored for the auto-documentation |
| History | Contains the detailed history of schema changes |
| Inventory | Contains the detailed inventory of database objects |
| Dependency | Contains the detailed inventory of database objects |
| LoadHistory | Tracks the loading history of the database |
| Neighbors | All PhotoObj pairs within 0.5 arcmins |
| Zone | Table to organize objects into declination zones |
| Match | records what objects in one run are re-observed in other runs. |
| MatchHead | describes each bundle of matching objects from different runs |
| Segment | Contains the basic parameters associated with a Segment |
| Field | Contains all the measured parameters of a photometric field |
| PhotoTag | Contains a popular fields of PhotoObj table |
| First | SDSS objects that match to FIRST objects have their match parameters stored here |
| Rosat | SDSS objects that match to ROSAT objects have their match parameters stored here. |
| USNO | SDSS objects that match to USNO objects have their match parameters stored here. |
| USNOB | SDSS objects that match to USNO-B objects have their match parameters stored here. |
| Chunk | Contains basic data for a Chunk |
| PhotoObjAll | Contains a record describing the attributes of each photometric object |
| PhotoAuxAll | The extra columns that didn't make it into the PhotoObjAll table. |
| FieldProfile | The mean PSF profile for the field as determined from bright stars. |
| RunQA | The RunQA table provides information relevant to the average data quality for the objects in each field. |
| PhotoProfile | The light profiles of SDSS photo objects |
| Mask | Contains a record describing the each mask object |
| MaskedObject | Contains the objects inside a specific mask |
| ObjMask | Contains a record describing each ObjMask/Atlas object |
| RC3 | The main PhotoObj table for the RC3 catalog |
| Stetson | The main PhotoObj table for the Stetson dataset. |
| Rmatrix | Contains various rotation matrices between spherical coordinate systems |
| Region | Definition of the different regions |
| RegionConvex | Defines the attributes of a given convex of a given region |
| HalfSpace | The contraints for boundaries of the the different regions |
| RegionArcs | Contains the arcs of a Region with their endpoints |
| Sector | Stores the information about set of unique tile overlaps. |
| BestTarget2Sector | Map PhotoObj which are potential targets to sectors |
| Sector2Tile | Match tiles to sectors, wedges adn sectorlets, and vice versa. |
| Region2Box | Tracks the parentage which regions contribute to which boxes |
| PlateX | Contains data from a given plate used for spectroscopic observations. |
| SpecObjAll | Contains the measured parameters for a spectrum. |
| SpecLineIndex | Precomputed spectral line indices. |
| SpecLineAll | Contains information about a single spectral Line |
| XCRedshift | Table of Cross-Correlation Redshifts |
| ELRedShift | Contains data for the Emission Line Redshifts |
| HoleObj | Information for holes on a Plate |
| SpecPhotoAll | The combined spectro and photo parameters of an object in SpecObjAll |
| QuasarCatalog | The DR3 Quasar Catalog from Schneider et al. NOTE: This is a derived science table that may not be loaded for every data release. It is scheduled to be reloaded for DR5. |
| QsoCatalogAll | A catalog of all the objects from Spectro, Best, or Target that "smell" like a QSO NOTE: This is a derived science table that may not be loaded for every data release. It is scheduled to be reloaded for DR5. |
| QsoConcordance | A concordance of all the objects from Spectro, Best, or Target that "smell" like a QSO NOTE: This is a derived science table that may not be loaded for every data release. It is scheduled to be reloaded for DR5. |
| Target | Keeps track of objects chosen by target selection and need to be tiled. |
| TargetInfo | Unique information for an object every time it is targetted |
| TargetParam | Contains the parameters used for a version of the target selection code |
| TileAll | Contains information about an individual tile on the sky. |
| TilingRun | Contains basic information for a run of tiling |
| TilingNote | Contains human readable notes for a run of tiling. |
| TilingGeometry | Geometric information about TilingRegions |
| TilingInfo | Contain info on what happened to a TargetObj in a run of tiling software. |
| Versions | Tracks the versioning history of the database |
| TiledTargetAll | Keep track of why a Target was assigned to a Tile |
| RecentQueries | |
| SiteDBs | |
| Photoz | The photometrically estimated redshifts for objects in the Galaxy view NOTE: This table may be empty initially because the photoz values are computed in a separate calculation after the main data release. |