Calling Database Guru's

[Silver_mani]

mamalu i want of list of tables along with their primary keys from the system catalog tables(db2 )........ elago koncham cheppandi flz

[Silver_mani]

evaru lera

[fair_pal]

calling mtkr

[mtkr]

[quote name='fair_pal' timestamp='1339550712' post='1301958825']
calling mtkr
[/quote]
nen endhu mama...
naaku db2 no idea....
only SQL(little)

[Silver_mani]

[quote name='fair_pal' timestamp='1339550712' post='1301958825']
calling mtkr
[/quote]

[Silver_mani]

[quote name='mtkr' timestamp='1339550770' post='1301958827']
nen endhu mama...
naaku db2 no idea....
only SQL(little)
[/quote]

[Gachibowli_Diwakar]

db2 aah inka niku telisthe maku nerpinchu db2 gurinchi

[Silver_mani]

[quote name='Silence..Please' timestamp='1339550869' post='1301958836']
db2 aah inka niku telisthe maku nerpinchu db2 gurinchi
[/quote]


neeku vere DB vacha mama ?

[mtkr]

[quote name='Silver_mani' timestamp='1339550808' post='1301958830']

[/quote]
endi mama aaa shock??

[Silver_mani]

[quote name='mtkr' timestamp='1339550996' post='1301958844']
endi mama aaa shock??
[/quote]


vurike mama ......sql aithe ela chestavu ?

[fair_pal]

[quote name='Silver_mani' timestamp='1339550966' post='1301958841']


neeku vere DB vacha mama ?
[/quote]

he is or dba

[Silver_mani]

[quote name='fair_pal' timestamp='1339551069' post='1301958851']

he is or dba
[/quote]


oh my bad .....

[mtkr]

[quote name='Silver_mani' timestamp='1339551037' post='1301958850']


vurike mama ......sql aithe ela chestavu ?
[/quote]


frst aithe ggle chestha mama...
ila direct ga adigithe kastam....

[Silver_mani]

[quote name='mtkr' timestamp='1339551421' post='1301958870']


frst aithe ggle chestha mama...
ila direct ga adigithe kastam....
[/quote]

aithe okasari google chey mama

[mtkr]

SQL lo eee script wrkng mama......



SELECT i.name AS IndexName,
OBJECT_NAME(ic.OBJECT_ID) AS TableName,
COL_NAME(ic.OBJECT_ID,ic.column_id) AS ColumnName
FROM sys.indexes AS i
INNER JOIN sys.index_columns AS ic
ON i.OBJECT_ID = ic.OBJECT_ID
AND i.index_id = ic.index_id
WHERE i.is_primary_key = 1