Toad World® Forums

Toad SQL Server Alter command Not creating proper Drop syntax. Missing brackets on object name


#1

ALTER

The Table below had a default value associated with a column.

The TableName has special characters in the name “Rel_3.3.2” which need to be put into brackets.

TABLE[dbo].[DailyReportData_REL_3.2.2_LastCSV]

DROP CONSTRAINT DF_DailyReportData_REL_3.2.2_LastCSV_ACN_Number

–The above syntax is incorrect and fails on the Drop Constraint due to the 'Rel_3.2.2" or periods.

— The BELOW syntax is correct and this is what Toad SQL Server should be generating on all object names.

TABLE [dbo].[DailyReportData_REL_3.2.2_LastCSV]

DROP CONSTRAINT [DF_DailyReportData_REL_3.2.2_LastCSV_ACN_Number]

GO


#2

Hi,

I can’t reproduce this issue, Here is my step:

1.I have create a table named DailyReportData_REL_3.2.2_LastCSV ,

2.add constraint for it(Alter table| Constratint tabe).

No matter I create constraint or drop it ,I can see the brackets.

Please point out if I do somthing different with your step?

Thanks,

Cathy.


#3

To Cathy Liu and Kelly Chen,

Thanks for the response…

I am going with address both issues at the same time for they are related.

Kelly, thanks I see that you understand the problem…

Cathy,

n Reference : http://www.toadworld.com/products/toad-for-sql-server/f/14/p/22482/48382.aspx#48382

n The problems are related, because of the Characters in the fully qualified database and table name.

o The syntax generated by the ALTER command using Toad SS 6.1 generates an error.

o Look at the table below my signature and in the attached file to see the error

o Use the attached file to recreate the problem on dropping the table default value

§ This is clearly reproducible and IT SHOULD BE NOTED that the brackets are present on the ADD default value but NOT the DROP syntax.

Kelly Chen

Cathy.Liu

From: Kelly.Chen [mailto:bounce-KellyChen@toadworld.com]
Sent: Thursday, August 14, 2014 11:10 PM
To: toadss@toadworld.com
Subject: RE: [Toad for SQL Server - Discussion Forum] Import Wizard not handling Ddatabase name where there are special characters.

RE: Import Wizard not handling Ddatabase name where there are special characters.

Reply by Kelly.Chen

Hi,

Thank you very much for your support. This is really a issue. And we have create TSS-638 for it.

Best regards,

Kelly

To reply, please reply-all to this email.

Stop receiving emails on this subject.
Or Unsubscribe from Toad for SQL Server - General notifications altogether.
Toad for SQL Server - Discussion Forum

Flag this post as spam/abuse.

From: Cathy.Liu [mailto:bounce-CathyLiu@toadworld.com]
Sent: Thursday, August 14, 2014 11:06 PM
To: toadss@toadworld.com
Subject: RE: [Toad for SQL Server - Discussion Forum] Toad SQL Server Alter command Not creating proper Drop syntax. Missing brackets on object name

RE: Toad SQL Server Alter command Not creating proper Drop syntax. Missing brackets on object name

Reply by Cathy.Liu

Hi,

I can’t reproduce this issue, Here is my step:

1.I have create a table named DailyReportData_REL_3.2.2_LastCSV ,

2.add constraint for it(Alter table| Constratint tabe).

No matter I create constraint or drop it ,I can see the brackets.

Please point out if I do somthing different with your step?

Thanks,

Cathy.

To reply, please reply-all to this email.

Stop receiving emails on this subject.
Or Unsubscribe from Toad for SQL Server - General notifications altogether.
Toad for SQL Server - Discussion Forum

Flag this post as spam/abuse.

The Table below had a default value associated with a column.

The TableName has special characters in the name “Rel_3.3.2” which need to be put into brackets.

TABLE[dbo].[DailyReportData_REL_3.2.2_LastCSV]

DROP CONSTRAINT DF_DailyReportData_REL_3.2.2_LastCSV_ACN_Number

–The above syntax is incorrect and fails on the Drop Constraint due to the 'Rel_3.2.2" or periods.


#4

Hi,

Thanks for your detailed information, I have reproduce this issues ,

Create TSS-645 for it.

Thanks,

Cathy.


#5

Thanks Cathy

Hank Freeman

Senior SQL Server DBA - Data and Solutions Architect

hfreeman@msn.com

678.414.0090 my cell Primary

Hank.Freeman50 (Skype)

From: Cathy.Liu [mailto:bounce-CathyLiu@toadworld.com]
Sent: Wednesday, August 20, 2014 12:36 AM
To: toadss@toadworld.com
Subject: RE: [Toad for SQL Server - Discussion Forum] Toad SQL Server Alter command Not creating proper Drop syntax. Missing brackets on object name

RE: Toad SQL Server Alter command Not creating proper Drop syntax. Missing brackets on object name

Reply by Cathy.Liu

Hi,

Thanks for your detailed information, I have reproduce this issues ,

Create TSS-645 for it.

Thanks,

Cathy.

To reply, please reply-all to this email.

Stop receiving emails on this subject.
Or Unsubscribe from Toad for SQL Server - General notifications altogether.
Toad for SQL Server - Discussion Forum

Flag this post as spam/abuse.

http://gyk.r.mailjet.com/o/04j0/c96c5256/usp1sl7e.gif