.
, , . , , , , . . , ; (., ) ..
( - ) objects :
SELECT NAME
FROM objects
where ID_TYPE=4
GROUP BY NAME
HAVING (COUNT(*) > 1)
, (. .)
, :
1: .
2: , , , , .
.
:
objects.ID_TYPE=types.ID_TYPE
objects.ID_OBJECT=objects_relation.ID_OBJECT_1 ( )
objects.ID_OBJECT=objects_relation.ID_OBJECT_2 ( )
objects_fields.ID_Field=Fields.ID_Field
objects_fields.ID_TYPE=types.ID_TYPE
objects_stat.ID_Field=Fields.ID_Field
objects.ID_OBJECT=objects_stat.ID_objects
, ID_TYPE objects , .
SQL- :
SELECT * FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE
:
.
" 201000 ".
:
-
-
-
-
-
-
-
- - .
:
" " . , . , . , , , . .
|
|
:
192, . .
" " / , .
:
- ,
- ,
- ,
- ,
- .
4 : , , , , . . .
: . . . . .
: , , , , - , , , .
:
- . / , .
:
- : , .
- : , .