The system catalog views sys.indexes and sys.index_columns make it easy to get a list of all indexes and index columns in a database. You may
Category: RDBMS
Add a CHECK constraint to the existing table
In this article, you’ll know how to add a CHECK constraint to the existing table. CREATE TABLE ActiveCustomersSummary ( SummaryID INT IDENTITY(1,1) PRIMARY KEY, CustomerID
Complex CHECK Constraints in SQL Server
Depending on your needs, SQL Server allows you to use a single CHECK constraint across multiple columns or numerous CHECK Constraints across a single column.
Column CHECK constraint for column ‘col1’ references another column, table ‘table1’.
Despite the fact that SQL Server permits the addition of multiple check constraints on a single column that is referenced by other columns in the
ENUM vs SET in MySQL
Have you ever used an application or filled out a web form with the radio buttons and checkboxes depicted below? Source: Google Image. Typically, the
ENUM Equivalent in SQL Server
An ENUM is a string object that has a value selected from a set of acceptable values that are explicitly listed in the column specification
Big Data & SQL 