STRUCTURED QUERY LANGUAGE(SQL) Created by: B Mokshagna Reddy (BMR) SQL DATA DEFINITION AND DATATYPES SQL Schema: An SQL schema is identified by a schema name and includes an authorization identifier name to indicate user or account who owns the schema, as well as descriptor for each elements in the schema. Schema creation with authorization: CREATE SCHEMA DATABASE_NAME AUTHORIZATION IDENTIFIER; Eg: CREATE SCHEMA COMPANY AUTHORIZATION ‘JSMITH’; Catalog: Named collection of schemas. Data Definition, Constraints, and Schema Changes Used to CREATE, DROP, and ALTER the descriptions of the tables (relations) of a database Creating a Database Syntax: CREATE DATABASE database_name; Creating a Table Syntax CREATE TABLE table_name (Column_name datatype[(size)], Column_name datatype[(size)], ); Specifies a new base relation by giving it a name, and specifying each of...
START EARNING WITH YoFan
Content from Yofan Website
Create your content
Create story-like posts or add to your links page. Your users can browse the content on your profile and sign up to receive notifications when you publish new content.Earn from ads
Using our partnership with Google AdSense, you can earn directly from the ads that are shown alongside your content. We meet the Better Ads Standard, and continuously improve ad performance.Share your profile
Your YoFan profile can be shared anywhere. Add it to your bio and share on social media. We also distribute your content to help you reach new audiences.Link to anything
You can link to other platforms using your Links page or you can tag your content with individual links. You can use the linking features for promoting affiliate products, your website or anything that lives on the web.Earn with Yofan
Comments
Post a Comment