Loading

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

thiru prakash

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?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Suthish Nair15y ago
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'