what is mean by constraints in sql?
- 5 Answers
- 7837 Views
- Granada, IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sethuraja
constraints are set of conditions which is ensure the field
data satisfy the conditions
| Is This Answer Correct ? | 19 Yes | 3 No |
Answer / sravanthi
Constaints are used to limit the data that can go into
table.
Basically, conditions are kept on columns in the table so
that data will insert based on those conditions.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / prabhu
It is used to limit the data that going in to the table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
Can a unique index be created on a column, which contains null?
What are constraints in microsoft sql server?
How to apply filtering criteria at group level with the having clause in ms sql server?
in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.
when you create a database how is it stored? : Sql server database administration
What is indexing in sql server with example?
What happens on checkpoint?
Explain the disadvantages of cursors?
* CREATE TABLE [dbo].[t_Colors]([ColorId] [int] NOT NULL,[ColorName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ColorDesc] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,[ColorIndex] [int] NULL) ON [PRIMARY] GO * insert into [t_Colors] values(101,'Red','',1) insert into [t_Colors] values(101,'Red1','',2) insert into [t_Colors] values(102,'Blue','',1) insert into [t_Colors] values(102,'Blue1','',2) insert into [t_Colors] values(102,'Blue2','',3) * In this table i need to delete DELETE FROM t_Colors WHERE ColorIndex=1 AND ColorId=102 After delete above condition i need to update the ColorIndex set to 1 for Blue1[ColorName] and 2 for Blue2[ColorName] select * from [t_Colors] Note:- how can i get updates the ColorIndex values after delete. for example we need to update Blue1 ColorIndex set to 1 and Blue2 ColorIndex set to 2
logshipping is Any difference 2000 and 2005?
How to create an inline table-valued function?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
