weixin_37704074的博客

DECLARE @SVOC_HIS_FULL_TBL_NM NVARCHAR(128); DECLARE @SVOC_TBL_OWNER NVARCHAR(10); DECLARE @SVOC_CUR_FULL_TBL_NM NVARCHAR(128); DECLARE @RERUN_DT NVARCHAR(10); DECLARE @NEW_EFF_DT NVARCHAR(100); DECLARE @JOIN_STMT

declare @TABLESPACE nvarchar(100)= 'oracle tablespace' declare @SCHEMA nvarchar(100)= 'oracle schema' declare @PRE nvarchar(100)= 'table prefix' declare @role nvarchar(100)= 'grant role name' declare @TABLENAME nvarchar(100)= 'sql server table_name' SE

查看表分区 SELECT o.name objectname,i.name indexname, partition_id, partition_number, [rows] FROM sys.partitions p INNER JOIN sys.objects o ON o.object_id=p.object_id INNER JOIN sys.indexes i ON i.object_id=p.object_id and p.index_id=i.index_id WHERE o.nam

–表重命名 sp_rename 'schema_name.old_table_name', 'new_table_name';

SQL Server 查看表结构 SELECT distinct TABLE_NAME=d.name, COLUMN_NAME=A.name, DATA_TYPE = B.name, CHAR_LENGTH=A.length, DATA_PRECISION=A.xprec, DATA_SCALE=A.xscale, NULLABLE = Case When A.isnullable=1 Then 'NULL' Else 'NOTNULL' End, PRIMARY_