I'm trying to learn....

Thursday, February 25, 2016

Change Schema For table in Sql 2014 by query

USE OnlinePOSDB
GO
ALTER SCHEMA Setup
TRANSFER [.Color]
GO
SELECT name, [schema] = SCHEMA_NAME(schema_id)
FROM   sys.tables
WHERE  name = '[.Color]'
GO
Posted by Unknown at 9:54 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Posts Older Posts Home
Subscribe to: Comments (Atom)

Categories

  • Design Pattern

Search This Blog

Popular Posts

  • Return Anonymous Type from method in C#
  • Access Modifier in c#
  • Change file from being flagged as a 'system file' back to 'normal' state on windows 7
  • Generics in c#
  • Data Vs Information
  • Polymorphism
  • Abstraction And Encapsulation
  • Introduction Design Pattern
  • Change Schema For table in Sql 2014 by query

Counter

Flag Counter

Blog Archive

  • ▼  2016 (1)
    • ▼  February (1)
      • Change Schema For table in Sql 2014 by query
  • ►  2015 (1)
    • ►  April (1)
  • ►  2014 (7)
    • ►  December (2)
    • ►  November (1)
    • ►  October (2)
    • ►  August (1)
    • ►  May (1)

About Me

Unknown
View my complete profile
Simple theme. Powered by Blogger.