FilesExpand file tree

 master

/

sql-server-constraints-with-examples.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

31 lines (27 loc) · 741 Bytes

 master

/

sql-server-constraints-with-examples.sql

Copy path

Top

File metadata and controls

• Code
• Blame

31 lines (27 loc) · 741 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

Select * from EmployeeDetails

Create table EmployeeDetails1

(

EmpID int Constraint empid_PK PRIMARY Key ,

EmpFirstName varchar(80),

EmpLastName varchar(80),

Department varchar(30),

DepartID int

)

SELECT * --constraint_name,

--constraint_type,

--search_condition

FROM user_constraints

WHERE table_name = 'EmployeeDetails';

SELECT OBJECT_NAME(OBJECT_ID) AS NameofConstraint,

SCHEMA_NAME(schema_id) AS SchemaName,

OBJECT_NAME(parent_object_id) AS TableName,

type_desc AS ConstraintType

FROM sys.objects

WHERE type_desc LIKE '%CONSTRAINT'

GO

SELECT CONSTRAINT_NAME,

TABLE_SCHEMA ,

TABLE_NAME,

CONSTRAINT_TYPE

FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS

WHERE TABLE_NAME='EmployeeDetails1'