I want to introduce about SQL Server Basic queries.
Database tables are objects that stores all the data in a database. In a table, data is logically organized in a row-and-column format which is similar to a spreadsheet. In a table, each row represents a unique record and each column represents a field in the record.
SQL Server uses schemas to logically groups tables and other database objects.
Database Offline By Sql Query:
1 2 3 |
USE master GO ALTER DATABASE YourDatabaseName SET OFFLINE WITH ROLLBACK IMMEDIATE GO |
Database Restore By Sql Query:
1 |
RESTORE DATABASE [DB1] FROM DISK = 'D:\new.bak' WITH REPLACE |
Table Create By Sql Query:
1 2 3 4 5 6 |
CREATE TABLE Persons ( ID int IDENTITY(1,1) PRIMARY KEY, LastName varchar(255) NOT NULL, FirstName varchar(255), Age int ); |