Key Data Element Code (KEY)
Definition: An indicator that identifies key and mandatory data within a data table. The indicators are "P" , primary key, "F", foreign key, "U", unique data element, or "M", mandatory, non-identifying data element. Key and unique data element data cannot have ...
Column Format
Definition: A specification for the length, type, and alphabetical attributes of a data element column. Need another definition?
Column Description
Definition: The noun phrase used to identify the data element. Sufficient modifiers are used with the noun name to ensure title uniqueness for a specific data element definition. Need another definition?
Column
Definition: A code, left-justified, used to identify the column and is unique within the table. Need another definition?
Table Title
Definition: A descriptive phrase used to identify the relational table. Sufficient adjectival modifiers are used with the phrase to ensure unique identification. Need another definition?
Trigger
Definition: A trigger is a SQL procedure that initiates an action when change (INSERT, DELETE or UPDATE) occurs. Each trigger is attached to a single, specified table in the database. A trigger cannot be called or executed but fires automatically as ...
Structured Query Language (SQL)
Definition: A special-purpose programming language designed for managing data held in a relational database management system (RDBMS). Need another definition?
Server Process Identifiers (SPID)
Definition: Server Process Identifiers are essentially sessions in SQL Server. Every time an application connects to SQL Server, a new connection (or SPID) is created. This connection has a defined scope and memory space and cannot interact with other SPIDs. The ...
Data Manipulation Language (DML)
Definition: Data Manipulation Language is a family of syntax elements in database programming used for inserting, deleting, and updating data. Need another definition?
Change Data Capture (CDC)
Definition: Change Data Capture records insert, update, and delete activity that is applied to a SQL Server table. Need another definition?
Get Connected