Mahesh Babu. Bokkisam

SQL objects are 1) schemas, 2) data dictionaries,  3) journals, 4) catalogs,  5) tables,  6) aliases,  7) views,  8) indexes,  9) constraints,  10) triggers,  11) sequences,  12) stored procedures,  14) user-defined functions,  15) user-defined types,  16) and SQL packages. SQL creates and maintains these objects as system objects.  A brief description of these objects follows :

In magento you can create as many custom attributes  for your products as you want.Suppose you want to add or display brand color for every product on home, category or product page. So this is very easy to do with custom attributes. If we were to create a new custom attribute called “brand_color” and the attribute was of a “Text Field” type, we could do something like the following at a product level to obtain its value. 1 echo $_product ->getBrandColor(); ?> Get attribute collection 1 $attribute = $_product ->getResource()->getAttribute( 'my_attribute' ); ?> Get attribute type 1 $attribute = $_product ->getResource()->getAttribute( 'my_attribute' )->getAttributeType(); ?> Get attribute Label 1 $attribute = $_product ->getResource()->getAttribute( 'my_attribute' )->getFrontendLabel(); ?> Attribute is visible or not 1 $attribute = $_produc