Sql

Search

sql database column values restrict

/// retrict column name rptIntervalUnit to just accept the ff values (Minutes,Days and Hours)
ALTER TABLE REPORTMODULES
ADD CONSTRAINT CK_INTERVALUNIT CHECK (rptIntervalUnit IN('Minutes','Days','Hours'))

Comment

PREVIOUS	NEXT

Code Example
Sql :: how to get recent added primary key in sql
Sql :: how to run parallel queries in sql server with entity framework
Sql :: Template MySQL Zabbix agent
Sql :: how to innjert in other database
Sql :: shows all databases created by user in ms sql
Sql :: mysql replication change database name
Sql :: tornado_mysql
Sql :: least spark sql
Sql :: save single sql query result boolean spring boot
Sql :: multiple row join
Sql :: query to fetch 50% records from the table.
Sql :: mysql where in maintain order
Sql :: select function with the column name we want to select
Sql :: docmd openargs
Sql :: r dbConnect(odbc::odbc() to ms sql server remote
Sql :: heroku postgres permission denied
Sql :: select count(*) from table
Sql :: systemverilog unique constraint unique values
Sql :: how to add postgres table in netbeans
Sql :: conectar base de datos mysql con java
Sql :: mysql update sequence with order by
Sql :: update or delete on table "model" violates foreign key constraint
Sql :: Resulting Query
Sql :: sql dmv to capture updates
Sql :: what is database username and password in mysqliconnect
Sql :: java mysql date format
Sql :: create table with error
Sql :: could not find driver (SQL: PRAGMA foreign_keys = ON;) larave
Sql :: ring SQLite sqlite_close
Sql :: select a row include list of array with join table SQL

Search

SQL

sql database column values restrict

ADD CONTENT