Senin, 30 Desember 2019

INFORMATION SCHEMA - SQL SERVER

Mencari Nama Field
SELECT * FROM INFORMATION_SCHEMA.COLUMNS

Cek Constraints
SELECT * FROM INFORMATION_SCHEMA.CHECK_CONSTRAINTS

List
    INFORMATION_SCHEMA.CHECK_CONSTRAINTS
    INFORMATION_SCHEMA.COLUMN_DOMAIN_USAGE
    INFORMATION_SCHEMA.COLUMN_PRIVILEGES
    INFORMATION_SCHEMA.COLUMNS
    INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE
    INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE
    INFORMATION_SCHEMA.DOMAIN_CONSTRAINTS
    INFORMATION_SCHEMA.DOMAINS
    INFORMATION_SCHEMA.KEY_COLUMN_USAGE
    INFORMATION_SCHEMA.PARAMETERS
    INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS
    INFORMATION_SCHEMA.ROUTINE_COLUMNS
    INFORMATION_SCHEMA.ROUTINES
    INFORMATION_SCHEMA.SCHEMATA
    INFORMATION_SCHEMA.TABLE_CONSTRAINTS
    INFORMATION_SCHEMA.TABLE_PRIVILEGES
    INFORMATION_SCHEMA.TABLES
    INFORMATION_SCHEMA.VIEW_COLUMN_USAGE
    INFORMATION_SCHEMA.VIEW_TABLE_USAGE
    INFORMATION_SCHEMA.VIEWS
di
Label:

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)

Dynamic Query - SQL Server

Berikut adalah contoh dari bentuk dari Dynamic Query di SQL Server yang dibungkus ke dalam Store Procedure:  USE [Data00] GO SET ANSI_NULLS ...

Popular Posts

  • Pembulatan Angka Desimal - SQL Server
    select round(5.123456 , 2) from dual ==> 5.12 select round(5.87654 , 2) from dual ==> 5.88 select floor(5.89) from dual ==> 5 s...
  • Tanggal - PostgreSQL
    UBAH FORMAT TANGGAL CONTOH DI DATABASE FORMATNYA YYYY/MM/DD, KITA UBAH JADI DD/MM/YYYY select a.nomor_register_aplikasi no_rekening, a.na...
  • Cara Restore Database PostgreSQL - PostgreSQL
    Contoh kita igin restore database di lokal: 1.create new database (jika sudah ada yg lama bisa di rename dulu, baru create yang baru) (cont...