Fetch all table names from a database (was "mssql server basic question!")

how to fetch all tables names from a database using a sql query
in my sql i can use query “use database_name; show tables;”
so how can i do it in mssql server
thanks

select table_name from information_schema.tables

thanks
but it retrieve the system tables
and i didn’t need the system tables i need only the tables i have been created with myself

add

where table_schema = 'tableowner'

thanks
and i found some useful examples
http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/06/29/850.aspx
thanks again