How many rows would this return? 🙂 (yes...it's different)
use AdventureWorks
go
declare @tableA TABLE(col1 int, col2 int)
go
--stmt 1
select name from tempdb.sys.tables where name like '%tableA%'
--stmt 2
select name from tempdb.sys.columns where name like 'col1%'
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein