Developing a naming standard

Developing a naming standard

The first step in any database design project is to develop a naming standard that will be used during the design process. While naming standard development is definitely not a requirement, continuing without some standard could yield an unorganized database that may present challenges to develop­ers when accessing the data. Inconsistent naming conventions often inhibit the development process indirectly? All the tables now have a common naming standard. Every new word begins with an uppercase letter, and the names are spelled completely.

Understanding schema

Database is the primary container of all objects, schemas offer another level of containment and organization within a database. Using a schema, a user can group objects of similar scope or ownership together. By default, the database owner (DBO) schema is automatically created within a database. Any object that is created is added to this schema.

Create a database schema using SSMS

1.     Open SSMS and connect to a SQL Server instance.

2.      Expand the Databases folder.

3.     Expand the “Thigalla” database.

4.     Expand the Security folder.

5.    Right-click the Schema folder and select New Schema from the context menu.

6.    In the Schema – New dialog box, type “Flowers” in the Schema Name text box and dbo in the   Schema Owner text box. Click ok.

Note:-You can grant users permissions to schemas.

Thanks & Regards  
Srikanth Goud-  Virtualization Administrator