Friday, June 24, 2022

List of banks Database Table SQL

CREATE TABLE [dbo].[MST_BANK](

[Bank_id] [int] NOT NULL,

[Bank_name] [varchar](100) NULL,

[Bank_status] [bit] NULL,

 CONSTRAINT [PK_BANK_MST] PRIMARY KEY CLUSTERED 

(

[Bank_id] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY],

 CONSTRAINT [IX_MST_BANK] UNIQUE NONCLUSTERED 

(

[Bank_name] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]

) ON [PRIMARY]

GO


ALTER TABLE [dbo].[MST_BANK] ADD  CONSTRAINT [DF_BANK_MST_Bank_status]  DEFAULT ((1)) FOR [Bank_status]

GO




 State Bank of India

Allahabad Bank

Indian Bank

Punjab National Bank

Gramya Bank

Mahila Gramya Bank

State Bank of Hyderabad

Dena Bank

Central Bank of India

Axis Bank

State Bank of Punjab

CANARA Bank

IDBI Bank

IndusInd Bank

State Bank of Patiala

State Bank of Mysore

Bank of India

Corporation Bank

Indian Overseas Bank

Union Bank

Oriental Bank of Commerce

Andhra Bank

Bank of Baroda

ICICI Bank

HDFC Bank

Kotak Mahindra Bank

Yes Bank

Standard Chartered Bank

Citibank

Deutsche Bank

Vijaya Bank

UCO Bank

State Bank of Bikaner and Jaipur

State Bank of Hydrabad

State Bank of Travancore

Bank of Maharastra

Punjab and Sind Bank

Syndicate Bank

Union Bank of India

United Bank of India

Dhanlaxmi Bank

Federal Bank

ING Vysya Bank

Karnataka Bank

South Indian Bank

J and K Grameen Bank

J and K Bank

Allahabad U P Gramin Bank

Gramin Bank of Aryavart

Uttar Pradesh Cooperative Bank Limited

Nagar Vikas Sahkari Bank

Bangia Gramin Vikas Bank

West Bengal State Cooperative Bank

The Union Cooperative Bank Ltd

HP State Cooperative  Bank Ltd

Himachal Gramin Bank

Bank of Maharashtra

Andhra Pradesh Grameena Vikas Bank

The Panchkula Central Cooperative Bank Ltd

The Panchkula Central Coop Bank Ltd

Bharatiya Mahila Bank

Visakhapatnam Cooperative Bank Ltd

Punjab Gramin Bank

Uttar Bihar Gramin Bank

Bangiya Gramin Vikas Bank

Chhattisgarh Rajya Gramin Bank

Karur Vysya Bank

Punjab and Maharashtra Cooperative Bank Ltd

BARODA UTTAR PRADESH GRAMIN BANK

MADHYA BIHAR GRAMIN BANK

LAKSHMI VILAS BANK

Catholic Syrian Bank

KAVERI GRAMINA BANK

LOKAPAVANI MAHILA SAHAKARI BANK

BARODA RURAL GRAMEENA BANK

BARODA RAJASTHAN KSHETRIYA GRAMIN BANK

BANGIYA GRAMIN BANK

JAIPUR THAR GRAMIN BANK

BANDHAN BANK

RAIGANJ CENTRAL COOPERATIVE BANK LIMITED

Andhrapragathi grameena bank

Sarva Haryana Gramin Bank

ODISHA GRAMYA BANK

SAPTAGIRI GRAMEENA BANK

Paschim Banga Gramin Bank

Telangana Grameena Bank

Central Cooperative Bank

Deccan Grameena Bank

Ratnakar Bank Limited

UTTARBANGA KSHETRIYA GRAMIN BANK

Tamilnad Mercantile Bank Limited

IDFC BANK LTD

Karnataka Bank Ltd

The South Canara Dist Central Coop Bank Ltd

AU Small Finance Bank

J and K State Cooperative Bank Ltd

No comments:

Post a Comment