USP_CODETABLESECURITY_GETCOLUMNSFROMTABLENAME
Gets columns names in the code table security table for the given table name.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @TABLENAME | nvarchar(100) | IN |
Definition
Copy
create procedure dbo.USP_CODETABLESECURITY_GETCOLUMNSFROMTABLENAME
(
@TABLENAME nvarchar(100)
)
as
set nocount on;
select
ID,
COLUMNNAME
from
dbo.CODETABLESECURITY
where
TABLENAME = @TABLENAME;