Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Table name with single quote in it

Status
Not open for further replies.

PROPAR

Programmer
Oct 25, 2001
51
FR
I use SQL Server 2005 and Visio 2003 Enterprise Architects.

SQL Server 2005 has no trouble with a table name with a single quote in it (like [dbo].[Satriale's Pork Store] for example) but Visio can't get it right when I try to reverse engineer : all tables with single quote fall on error and Visio doesn't seem to put [ ] around tables names.

Is there something I can do ?
(better of course than to rename my table as [dbo].[Satriale_s Pork Store], which is not an option...)

Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top