Simon's Bits and Bobs

Monday, 25 January 2016

MS SQL Server - Chaning table's schema

Changing table schema 
ALTER SCHEMA schema_name TRANSFER schema_name.table_name;

Posted by Simon Turner at 06:25
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

About Me

Simon Turner
View my complete profile

Blog Archive

  • ▼  2016 (23)
    • ►  October (1)
    • ►  September (1)
    • ►  August (1)
    • ►  July (6)
    • ►  June (2)
    • ►  March (1)
    • ►  February (1)
    • ▼  January (10)
      • MS SQL Server - How to determine the active node o...
      • MS SQL Server - Configure and grant user access t...
      • MS SQL Server - Shrinking transaction logs
      • MS SQL Server - Chaning table's schema
      • MS SQL Server - How to reindex all tables within ...
      • MS SQL Server - Moving temp DB location
      • MS SQL Server - Script all SQL Logins with their o...
      • MS SQL Server - Stored procedure or function chang...
      • MS SQL Server - Script Object
      • MS SQL Server - Search for string in all stored pr...
Simple theme. Powered by Blogger.