Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Renaming a View name

24 posts

BigBaz posted 2 years ago in General

Hi I'm trying to rename a view name. When I press the Save button I get the error shown in the attached screenshot. As there is no keyword 'TABLE' used in the name or the view code I've no idea what the error is.

1 attachment(s):

9770 posts

ansgar posted 2 years ago

That happens in MSSQL mode, right? The syntax used for renaming a view is for MySQL only. I don't know if it's possible to rename a view in MSSQL at all.

24 posts

BigBaz posted 2 years ago

Hi In Management Studio I've just tried renaming a view and it worked OK.

Please login to leave a reply, or register at first.