Change schema name on Tables and Stored procedures

Hi,

Is there a way I can change schema name on tables and stored procedures? How do I do this?

I´m very news to SQL and .net

Thanks

You can use ALTER SCHEMA command, the following command will transfer mytable under myschema to dbo schema:

ALTER SCHEMA dbo TRANSFERmyschema.mytable

For more information, you can refer to:

http://msdn2.microsoft.com/en-us/library/ms173423.aspx