Can we create a table in a database without dbo permissions.?

I have to create a table in one da开发者_C百科tabase where I have no dbo permission.

Can I do that?

---

Yes, you can create a table as long as you are a member of the db_owner or db_ddladmin database roles, or if you are explicitly granted the CREATE TABLE permission. Obviously, if you're in the sysadmin server role you can also create tables.

You can't necessarily read or modify data inside the table(s) you create, but you can create them.

These permissions are not defaults, so if you have not been granted any of these you're out of luck unless your dba will do so for you.