SQL Server Objects

First item: Renaming an Object

Execute sp_rename @objname = ' Nums ', @newname = ' Numbers ', @objtype = ' object ';

Go

Be especially careful here @newname this parameter does not take a schema such as: @newname = ' dbo. Numbers ' This is not good, the table of the new table name will be dbo.dbo.Numbers;

All for sp_rename This statement does not take the schema.

Second item: Object Transfer schema.

Transfer the numbers table from dbo to NiNi

Alter Shema NiNi transfer dbo. Numbers;

Third item: viewing object definitions

Select Object_definition (object_id (dbo. ' Uvw_v '));

Go

Caution: The table here is not considered an object. This means that the table definition cannot be viewed with object_definition.

SQL Server Objects