SQLQuery1.sql

CREATE TABLE users (
    id            INT PRIMARY KEY IDENTITY(1,1),
    email         NVARCHAR(100),
    username      NVARCHAR(50),
    password      NVARCHAR(100),
    date_register DATE 
)
SELECT * FROM users

CREATE TABLE books (
    id             INT PRIMARY KEY IDENTITY(1,1),
    book_title     VARCHAR(100),
    author         VARCHAR(100),
    published      VARCHAR(50),
    status         VARCHAR(50),
    date_insert    DATETIME DEFAULT GETDATE(),
    date_updated   DATETIME NULL,
    date_deleted   DATETIME NULL
)
SELECT * FROM books

ALTER TABLE books 
ADD image  VARCHAR(50)
SELECT * FROM books
 
 ALTER TABLE books ALTER COLUMN published DATE;
 SELECT * FROM books
 
SELECT name FROM sys.databases

SELECT TABLE_CATALOG, TABLE_NAME 
FROM INFORMATION_SCHEMA.TABLES 
WHERE TABLE_NAME = 'books'