Home / Tag Archives: database

Tag Archives: database

Database level Queries & Identity functions

Database

Get list of tables in the Database: We can get all the tables in the database by using one of the following queries. SELECT * FROM SYS.OBJECTS WHERE TYPE=’u’ SELECT * FROM INFORMATION_SCHEMA.TABLES Get list of columns of a Table: To get the list of columns present in the table, ...

Read More »

People Who Work With The Database

Database

The people who use the database can be categorized into two different category , these are as follows: Database users Database administrator (DBA) Database clients are of four distinct sorts: 1) Naive clients: These are the unsophisticated clients who connect with the framework by summoning one of the application programs ...

Read More »

How to create table in SQL database?

create table

Create table in SQL Database. In below article we will see how to create table , delete table, update table and select table in qul database .It is easy to create table in sql. Create Table Command: To create table in the database following syntax is used. Create Table < ...

Read More »

Guide about Database Constraints

Constraints

Database Constraints: Constraint is the rules/conditions imposed on the columns & tables to maintain the data integrity of the database. Constraints are of 2 types, Declarative Integrity Constraint: These constraints can be imposed at the time of table or column creation. Procedural Integrity Constraint: These constraints cannot be imposed at ...

Read More »