Changing Table Schema

SELECT ‘ALTER SCHEMA zam TRANSFER ‘ + SCHEMA_NAME(schema_id) + ‘.’ + name
FROM sys.tables
WHERE schema_id = SCHEMA_ID(‘dbo’)
AND [name] not like N’%_InventorySkus’
AND [name] not like N’%_CatalogProducts’
AND [name] not like N’%_CatalogDeletedProducts’
AND [name] not like N’%_CatalogRelationships’
AND [name] not like N’%_CatalogHierarchy’
AND [name] not like N’%_Catalog’
AND [name] not like N’%_CatalogDependentCatalogs’

Also check out following link ..::.. Changing Basket Limits
http://msdn.microsoft.com/en-us/library/ms960085.aspx

— For instance, in order to transfer dbo.[All_tr-TR] to zam.[All_tr-TR]
ALTER SCHEMA zam TRANSFER dbo.[All_tr-TR]