is it possoble to create a database having only one table in sql server 2005?

Question

hi
can we create a database in sql server 2005 which contains only one table and the table can contain any number of records but it should not allow to add another table and restrict us to create another table in same database.
how to achieve this?

Suthish Nair · Answer

I think you can't. You can restrict users to access existing and creating tables. Else other workaround is using below query to check the tables count existing in a Database. SELECT * from information_schema.tables WHERE table_type = 'base table'