Virtually all major spatial vendors have created their own SRID implementation or refer to those of an authority, such as the EPSG Geodetic Parameter Dataset.
CREATE TABLE SPATIAL_REF_SYS
(
SRID INTEGER NOT NULL PRIMARY KEY,
AUTH_NAME CHARACTER VARYING(256),
AUTH_SRID INTEGER,
SRTEXT CHARACTER VARYING(2048)
)
PROJCS["NAD27(76) / UTM zone 17N",
GEOGCS["NAD27(76)",
DATUM["North_American_Datum_1927_1976",
SPHEROID["Clarke 1866",6378206.4,294.9786982138982,
AUTHORITY["EPSG","7008"]],
AUTHORITY["EPSG","6608"]],
PRIMEM["Greenwich",0,
AUTHORITY["EPSG","8901"]],
UNIT["degree",0.01745329251994328,
AUTHORITY["EPSG","9122"]],
AUTHORITY["EPSG","4608"]],
UNIT["metre",1,
AUTHORITY["EPSG","9001"]],
PROJECTION["Transverse_Mercator"],
PARAMETER["latitude_of_origin",0],
PARAMETER["central_meridian",-81],
PARAMETER["scale_factor",0.9996],
PARAMETER["false_easting",500000],
PARAMETER["false_northing",0],
AUTHORITY["EPSG","2029"],
AXIS["Easting",EAST],
AXIS["Northing",NORTH]]
GEOGCS["WGS 84",
DATUM["WGS_1984",
SPHEROID["WGS 84",6378137,298.257223563,
AUTHORITY["EPSG","7030"]],
AUTHORITY["EPSG","6326"]],
PRIMEM["Greenwich",0,
AUTHORITY["EPSG","8901"]],
UNIT["degree",0.01745329251994328,
AUTHORITY["EPSG","9122"]],
AUTHORITY["EPSG","4326"]]
SRID values associated with spatial data can be used to constrain spatial operations — for instance, spatial operations cannot be performed between spatial objects with differing SRIDs in some systems, or trigger coordinate system transformations between spatial objects in others.