sql-serverteradatadbo

dbo in SqlServer

I'm converting database from Teradata to SqlServer. I've noticed all tables and procedures are named by the prefix "dbo." (e.g. "dbo.Table1").

I would like to know if and how I can get rid of "dbo" because it would make the conversion task a lot more easier.

Solution

  • dbo is not part of the table name. It is the name of the schema that the tables and stored procedures are attached to. dbo is the default schema in SQL server, though you can add others if needed.

    See this MSDN article about them.