Monday, April 23, 2012

ALTER TABLE

In earlier versions, you can use later statement for tables, specifying four part table names. For example specifying the format .database.schema.table or the format ..schema.table will be succeeded. However, in SQL Server 2012 it will fail.

image

So in case you have referenced tables when altering them as a four part table name, make sure you change them. You might not use this type of statements directly however there are chances that applications, will use for ad-hoc queries.

1 comment:

  1. LinkedIn Group: SQLServerCentral
    Discussion:ALTER TABLE

    Interesting, but my question is : why does this now fail ?
    Posted by Simon Clark

    ReplyDelete