create table for every user

Hello Chathurika,

 As my personal view, create a table for every customer is not a good idea, even though i don't know about your full requirement.

So, you can achieve in one of the way at SQL server level is:

1. First insert all the customers in one table
2. create a stored procedure like the below
CREATE PROCEDURE CustomerTableCreation(
@Name NVARCHAR(100)
)
AS
BEGIN
DECLARE @SQL NVARCHAR(1000)
SET @SQL = 'CREATE TABLE ' + @Name + '(Id INT)'
EXEC(@SQL)
END
3.  create one cursor it gets the customer names and create a table for all customer names
DECLARE @name VARCHAR(100)
DECLARE db_cursor CURSOR FOR
SELECT distinct Name
FROM Customer

OPEN db_cursor
FETCH NEXT FROM db_cursor INTO @name

WHILE @@FETCH_STATUS = 0
BEGIN
        EXEC CustomerTableCreation @name
        FETCH NEXT FROM db_cursor INTO @name
END

CLOSE db_cursor
DEALLOCATE db_cursor

Note: The customer name/id should satisfy the table name conditions in sql server (Table Name Format, Unique Table Name etc)

If you want to achieve through code level,
you can call the stored procedure (mentioned in 2nd point) from code level. it would creates a table for you..

Thanks,
Ramchand.

This is the wrong way if you create the table for every user. suppose have in your data around one thousand records then what you create one thousand table. just create a single table for user records. if you want add more information like account related , address , job company and so on. create different table and join with every one. it's a simple and fast performance.