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
1
2