<prompt> Tengeneza hati ya T-SQL inayorejesha maelezo kuhusu majedwali ya hifadhidata na uhusiano wao katika mfano wa Seva ya SQL.PLINFORMAT  <response>: -- Tangaza vigeuTANGAZA DatabaseName NVARCHAR128 YourDatabaseName;-- Weka muktadha kwenye hifadhidata unayotakaTUMIA bwana;IKIWA IPO CHAGUA KUTOKA sys.databases WAPI jina DatabaseNameANZA EXECTUMIA DatabaseName ;MWISHOVINGINEVYOANZA CHAPISHA Hifadhi hifadhidata iliyobainishwa haipo.; RUDISHA;MWISHO-- Leta jedwali, safu wima, ufunguo msingi, na taarifa muhimu za kigeniCHAGUA SCHEMA_NAMEt.schema_id AS SchemaName, t.name AS JedwaliName, c.pe jina la safu wima ya AS, ty.name AS DataType, c.max_length AS MaxLength, c.usahihi AS Usahihi, c.scale AS Scale, c.is_nullable AS Isnullable, pk.ConstraintName AS PrimaryKeyName, fk.ForeignKeyName, fk.ReferencedSchemaName, fk.ReferencedTableName, fk.ReferencedColumnNameKUTOKA sys.meza tJIUNGE NA NDANI sys.columns c ON t.object_id c.object_idJIUNGE NA NDANI sys.types ty ON c.user_type_id ty.user_type_idKUSHOTO JIUNGE CHAGUA kitambulisho_cha_kitu, ic.column_id, k.jina AS ConstraintName KUTOKA sys.index_columns ic JIUNGE NA NDANI sys.indexes i KWENYE ic.object_id i.object_id NA ic.index_id i.index_id JIUNGE NA NDANI sys.key_constraints k ON i.object_id k.parent_object_id NA i.index_id k.unique_index_id WAPI i.is_primary_key 1 pk KWENYE t.object_id pk.object_id NA c.column_id pk.column_idKUSHOTO JIUNGE CHAGUA kitambulisho_cha_kitu_cha_mzazi, kitambulisho_cha_cha_cha_cha_cha_cha_cha_mzazi, f. jina AS ForeignKeyName, SCHEMA_NAMErt.schema_id AS ReferencedSchemaName, rt.name AS ReferencedTableName, rc.name AS ReferencedColumnName KUTOKA sys.funguo_za_kigeni f JIUNGE NA NDANI sys.foreign_key_columns fkc ILIYO f.object_id fkc.constraint_object_id JIUNGE NA NDANI sys.tables rt ILIYO Fkc.referenced_object_id rt.object_id JIUNGE NA NDANI sys.columns rc ILIYO fkc.referenced_object_id rc.object_id NA fkc.referenced_column_id rc.column_id fk KWENYE t.object_id fk.parent_object_id NA c.column_id fk.parent_column_idAGIZA KWA SchemaName, JedwaliName, ColumnName; 