Options

SQL-Compare script without schema qualifiers

RadhikaRadhika Posts: 2
edited February 28, 2007 9:08AM in SQL Compare Previous Versions
Hi,

We want an SQL script to be generated from SQL-Compare without having schema qualifiers to the database objects.

For e.g. - currently the script that we are getting from SQL-Compare contains the schema qualifiers as:
CREATE TABLE [dbo].[test_table]
(.
.
)

We want it to be:
CREATE TABLE [test_table]
(.
.
)

Note that [dbo] is now removed from the create script. We can not find any setting in SQL-Compare that gives an option to remove this schema qualifier.

Please let us know if anybody has come across same problem and have found a solution for the same.

Thanks in advance,
Radhika
Sign In or Register to comment.