Sql Object Schema

So inorder to Find a table schema in sql you have two options

-- this will show all tables within this database
SP_TABLES

-- this is a more selective search
select * from
INFORMATION_SCHEMA.tables
WHERE TABLE_NAME =

this can also be done with columns

-- this will show all column definations within the table specfied
SP_Columns

-- this is a more selective search on one or many views at one time
select * from
INFORMATION_SCHEMA.columns
WHERE TABLE_NAME =