subject: Know All About Sql Objects And Recovery Of Sql Database Objects [print this page] SQL Server is a contribution from Microsoft which is available to use on large organizations like educational institutions, medical center etc. Now, the components in SQL Server are prone to corruption, which is important to take care of. When the data stored in SQL Server lead to serious corruption Recovery of SQL Database Objects, becomes crucial otherwise data cannot be accessed and cannot be used at all.
List of Components in SQL Server: Given below are some of the components present in SQL Server with brief explanation:
Tables: Tables provide the entity like you have stored customer information in table. Customer is an entity here and entire rows in customers table show the instances of customer. Mostly large organizations use entity to represent because table store numerous instances of customers.
Views: Views are similar to tables, but with little bit of differences like unlike tables it does represent single entity, it can be a combination of two entities like AuthorName, ResidentialAddress etc.
Stored Procedures: Stores procedures are action-oriented used for describing work they do. Here, it is better to use verb. For example, WriteCustomer Details, TakeAudioClippings etc. It is basically for customer details
User Defined Functions: UDFs is abbreviated for User Defined Functions; it is similar to stored procedures. These can be used in select statements. Use prefix or suffix to make group for your UDFs.
Triggers: For using triggers it is required to extend name convention, although they are much similar to stored procedures, but extension make them different from stored procedures. The operations followed in triggers are Insert, Delete, Update, etc
Indexes: Indexes are somewhat similar to triggers, dependant on base tables. Thus on index name, include name of the table, columns name. There are two types of indexes clustered and non-clustered.
Columns: Columns provide entity and describe properties on entity. So, it is important that columns name should be attractive and meaning describing. For example CustomerContactNumber, CustomerSurmName etc
User Defined Data Types: This component in SQL Server is helpful to maintain consistency in data types.
Primary Keys: Primary keys are essential to identify row in a table. So, use column name prefixed as pk_ +Column name. Here pk denotes Primary Key)
Foreign Keys: Such type of keys shows the relationship between related tables.
Default and Check Constraints: Use column name to which check and constraints are bound use prefix chk for Check anddef for Default.
Variables: Variable is the store house of content in columns, use same convention that is used for column names.
Recovery of SQL Database Objects: If the above mentioned components lead to corruption due to any reason, use external software like SQL Repair Tool. This scintillating solution provides you with complete recovered components in your hand.
