SQL quick reminder please

[Pav1977]

Hi there - I forgot my SQL book today and can't remember how to search all the tables in a database.
It requires to have FROM and is not taking *.

I know this is stupid - I'd much appreciate your help guys.

So it would be soething like this:
SELECT *
FROM - all tables in a database?
WHERE (PageId = '14061')

 

[chipk]

Put the name of the database in the FROM statement, for example, Master:

SELECT *
FROM master
WHERE (PageId = '14061')

 

[Pav1977]

I should have said that I tried it - and it can't find the column in tables

I'm trying to search for a value in a specitic colum in all of the tables. I know that the column exists in at least 2 tables - and need to find out if there is more.

Cheers