Geek Answers Handbook

In SQL Server 2008 R2 - can you rename a table in a database chart tool?

I am using a version of the SQL Server 2008 R2 database chart tool. Searching as I could, I cannot find a way to rename tables in the user interface. Is it really impossible? Renaming a column is easy, but the only way I was able to “rename” tables is to recreate it with a new name, establish the appropriate foreign key relationship, and delete the old table.

thanks Sylvia

+8
sql database sql-server-2008 database-design
source share
3 answers

No, you cannot do this. However, just by clicking on the table in the object explorer, press F2 and rename it

+6
source share

Yes, you can rename the table in the Chart tool. If you select a table, you can change the name of the table in the Properties panel. If you don’t see the Properties panel, just press F4 and it should automatically appear on the right side of Studio Manager.

The top section of the properties is (Identity), and Name is the first property. Just change the value of the Name property and save.

+6
source share

You can rename the table. We can change the name of an existing table with the following code.

EXECUTE sp_rename 'oldTableName', 'newTableName'

EXECUTE sp_rename 'tb1', 'tb2'

Really try it.

+4
source share

More articles:


All Articles