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
