How to rename a table in SQLite 3.0?
ALTER TABLE `foo` RENAME TO `bar` SQLite Query Language: ALTER TABLE
ALTER TABLE `foo` RENAME TO `bar` SQLite Query Language: ALTER TABLE
Using sys.dm_sql_referencing_entities: SELECT referencing_schema_name, referencing_entity_name, referencing_id, referencing_class_desc, is_caller_dependent FROM sys.dm_sql_referencing_entities (‘mySchemaName.myTableName’, ‘OBJECT’); GO where ‘mySchemaName.myTableName’ is your schema.table, for example ‘dbo.MyTable’
No. While other actions can be combined, that’s not possible with RENAME. The manual: All the forms of ALTER TABLE that act on a single table, except RENAME, SET SCHEMA, ATTACH PARTITION, and DETACH PARTITION can be combined into a list of multiple alterations to be applied together. Since RENAME is a tiny operation on … Read more
ALTER TABLE mytable RENAME TO othertable In Oracle 10g also: RENAME mytable TO othertable
group is a keyword (part of GROUP BY) in MySQL, you need to surround it with backticks to show MySQL that you want it interpreted as a table name: RENAME TABLE `group` TO `member`; added(see comments)- Those are not single quotes.