how to create a schema and how to apply schema.
CREATE SCHEMA SchemaName;
or go to expand the database and goto security folder then expand and create the schema.
it will create under the schema.
- here if we create any database it will create under dbo.
we want to create under our created schema
create a table and add primary key and auto-increment
then right-click on properties and change schema. that's it njoy...
CREATE SCHEMA SchemaName;
or go to expand the database and goto security folder then expand and create the schema.
it will create under the schema.
- here if we create any database it will create under dbo.
we want to create under our created schema
create a table and add primary key and auto-increment
then right-click on properties and change schema. that's it njoy...