본문 바로가기

프로그래밍/MSSQL

 (12)
MS SQL - PRIMARY KEY 와 FOREIGN KEY 를 전부 뽑아주는 쿼리 Method 1: INFORMATION_SCHEMASELECT DISTINCT Constraint_Name AS [Constraint], Table_Schema AS [Schema], Table_Name AS [TableName] FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE GOMethod 2: sys.objectsSELECT OBJECT_NAME(OBJECT_ID) AS NameofConstraint, SCHEMA_NAME(schema_id) AS SchemaName, OBJECT_NAME(parent_object_id) AS TableName, type_desc AS ConstraintType FROM sys.objects WHERE type_desc IN ('FOREIG..
MS SQL - 기존 DB의 레코드 정보를 INSERT문으로 뽑아내기 MS SQL - 기존 DB의 레코드 정보를 INSERT문으로 뽑아내기 SELECT 'INSERT INTO [테이블명] (parentId,joinerId,code,content,link,state,step (' +(CASE WHEN convert(nchar(10),isnull(parentId,'NULL'))='' THEN 'NULL' ELSE convert(nchar(10),isnull(parentId,'NULL')) END) +',' +convert(nchar(10),joinerId) +','+(CASE WHEN convert(nchar(10),isnull(code,'NULL'))='' THEN 'NULL' ELSE convert(nchar(10),isnull(code,'NULL')) END) +',' ..

티스토리툴바