How to find The occurence of a particular Column in a database
SELET O.Name
FROM sysobjects AS O
JOIN syscolumns AS C
on C.id = O.ID
WHERE C.Name = 'columnName'
sysobjects :To find the tables
syscolumns:-To locate a specific column
Monday, May 7, 2007
How to find The occurence of a particular Column in a database
Subscribe to:
Post Comments (Atom)
2 comments:
thnks dear
i really helped me alot
was quite use full for our DBA will help in fixing many hurdles.:)
Post a Comment