Questions tagged [sp-rename]
17 questions
0
votes
2 answers
Calling sp_rename on a table kills database connection in Sybase
I'm trying to rename a table using the following syntax
sp_rename [oldname],[newname]
but any time I run this, I get the following [using Aqua Datastudio]:
Command was executed successfully
Warnings: --->
W (1): The SQL Server is terminating…

glasnt
- 2,865
- 5
- 35
- 55
0
votes
1 answer
SQL Server renaming tables with contraints
very simple predicament I am in.
Basically I have four tables with primary/foreign keys and cascade constraints something like this.
CREATE TABLE [Board]
(
[BoardId] [int] IDENTITY(1,1) NOT NULL PRIMARY KEY CLUSTERED ( [BoardId] )
,[Name]…

iiminov
- 969
- 1
- 15
- 34