Database

Ali Al Omairi(Abu AlHassan) wrote:

Guys I have joke;

Ali Al Omairi(Abu AlHassan) wrote:

Guys I have joke;

who know what is the opposite of 'Safe'?

Ali Al Omairi(Abu AlHassan) wrote:

Sir, what is your problem with that?

select
  parobj.name as 'ParentTable',
  concol.name as 'ConstrantColumn',
  refobj.name as 'ReferencedTable',
  refcol.name as 'ReferencedColumn'
from sys.foreign_key_columns
inner join sys.objects as parobj
  on parobj.object_id = sys.foreign_key_columns.parent_object_id
inner join sys.columns  as concol
  on concol.column_id = sys.foreign_key_columns.constraint_column_id and
     concol.object_id = sys.foreign_key_columns.parent_object_id
inner join sys.objects as refobj
  on refobj.object_id = sys.foreign_key_columns.referenced_object_id
inner join sys.columns  as refcol
  on refcol.column_id = sys.foreign_key_columns.referenced_column_id and
     refcol.object_id = sys.foreign_key_columns.referenced_object_id

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'

order by length(MyCode), MyCode

Mycroft Holmes wrote:

select fname, lname from employee where 1=1

Mycroft Holmes wrote:

where 1=1