Hi all,
Need a big favour, I have to collect information like
TableName-> it's all columnNames--> dependent table name of EachColumn(where this column is refrenced)
I have managed to get some info like:-
select so.name as 'Table Name',sc.name as 'Column Name',st.[name], sc.length,sc.isnullable,so.crdate
from syscolumns sc
inner join sysobjects so on so.id=sc.id
inner join systypes st on st.xtype= sc.xtype
where so.xtype='U'
order by so.name
sp_depends and sp_MSdependencies is not returning me same fields..I would start with sysobjects, syscolumns and sysreferences. Try the query and if you get stuck, let us know
Thursday, February 16, 2012
Checking columns level dependencies
Labels:
checking,
collect,
columnnames-gt,
columns,
database,
dependencies,
dependent,
eachcolumn,
favour,
level,
microsoft,
mysql,
oracle,
server,
sql,
table,
tablename-gt
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment