Need function to return single value

[VicRauch]

I'm trying to get a list of column names with their table name for every column in my database that is an Identity column. Where I have hung up is trying to figure out how to write a function that will return True or False (for IsIndentity) when given the TableName and ColumnName. I'm just getting started with T-SQL.

Thanks,
Vic

 

[harebrain]

See the ColumnProperty() function in BOL.