Windows admin part: SELECT NAME
PHYSICAL SCHEMA: which is created by company like logs
LOGICAL SCHEMA: which is created by us
SELECT NAME FROM sys.databases
CREATE DATABASE db_name
CREATE TABLE_NAME ( FIELD_NAME DATA_TYPE IDENTITY(STARTING FROM, INCREASE BY) PRIMARY KEY, )
CREATE TABLE_NAME ( FIELD_NAME DATA_TYPE IDENTITY(STARTING FROM, INCREASE BY) PRIMARY KEY, FIELD_NAME DATA_TYPE FOREIGN KEY REFERENCES TABLE_NAME(PRIMARY KEY_FIELD), )
INSERT INTO tablename (col1, col2) values (column1data, column2data )
UPDATE INTO tablename SET (UpdData) where Col = value
DELETE FROM tablename where col = value;
ALTER TABLE tablename ADD colname data type
ALTER TABLE tablename DROP colname
ALTER TABLE tablename ALTER column colname datatype