hi
i have a error in this query plz help me to fix it.(my error is syntax error near create )
Session["userName"]= User.Identity.Name;
string u = Session["userName"].ToString();
string query1 = null;
query1 = string.Format("CREATE SCHEMA {0} AUTHORIZATION SOBHAN; CREATE TABLE {0}.Profile(ID uniqueidentifier not null REFERENCES aspnet_Users(UserId),name nvarchar(20) not null,about text null,pic image null); CREATE TABLE {0}.Friend (ID uniqueidentifier not null REFERENCES aspnet_Users(UserId),name nvarchar(20) not null,popular bit null); CREATE TABLE {0}.Post(ID_Post int not null PRIMARY KEY,sendItem text null,Img image null);", u);
Go to the complete details ...