Wilhelm Tell - Hoe kunnen we eenvoudig de column typen van een tabel ophalen in Sybase

Type:

Aanvraag Handleiding

Subtype:

Basisfunctie

Status:

Testen

Prioriteit:

Middel

Code:

Sybase

Versie:

20090812

Referentie:

1313

Remko

Posted by: Remko (Super Admin) on 12-08-2009 @ 13:45:52

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:

Set RowCount 300

Declare @Column Varchar(50)
,     @Table Varchar(25)

Select @Column = "jecolumnnaam"
,     @Table = "jetabelnaam"

Select "ColumnName" = C.name
,     "TableName"     = O.name
, P.Name
, P.Type
, P.Domain
, P.Hierarchy
From syscolumns C
,     sysobjects     O
,     systypes          P
Where      ( C.Name     = @Column or @Column = null)
And          C.id = O.Id
And           O.Name = @Table
And          C.UserType     = P.UserType

Set RowCount 0

Veel succes.