Check constraints should be visible in the GUI

tbayart / sql-server-data-producer

Automatically exported from code.google.com/p/sql-server-data-producer

0 stars 0 forks source link

Check constraints should be visible in the GUI #89

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago

The check constraints on each column should be visible in the GUI so that the 
user can create data that will fit the constraint

Original issue reported on code.google.com by a03pe...@gmail.com on 14 Nov 2012 at 9:33

GoogleCodeExporter commented 9 years ago


SELECT TABLE_NAME, COLUMN_NAME, c.CONSTRAINT_NAME, CHECK_CLAUSE
FROM 
INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE cu
inner join
INFORMATION_SCHEMA.CHECK_CONSTRAINTS c
on cu.CONSTRAINT_NAME = c.CONSTRAINT_NAME
order by TABLE_NAME

Original comment by a03pe...@gmail.com on 14 Nov 2012 at 9:36

GoogleCodeExporter commented 9 years ago

Original comment by a03pe...@gmail.com on 3 Dec 2012 at 3:58

Changed state: Started

GoogleCodeExporter commented 9 years ago

Original comment by a03pe...@gmail.com on 4 Dec 2012 at 10:32

Changed state: Fixed